根据最后一行在Excel中选择多行

I have a piece of code which selects the entire row from my table based on the last data in column K. E.g. if I have rows 5 to 10 populated, it will select row 10.I have a piece of code which selects the entire