Select to the Last Row or Column With Data in Excel using VBA Macro

Gracias Crack!

I need to paste the values in the last row. How do you do that?

Thank you for sharing this code. Superb

when there is an blank cell in the middle of column A, how to go to last filled row Sir

Thanks very short video with detailed knowledge sharing...🙏💥🙏

Thank you, that solved my issue for selection of table

Thank you for sharing and explaining the code. If I want it to select down to the very last row, in your case it is row #13. The VBA code doesn't work if there is a blank cell in between. Please help.

Indeed Great.. got half of answer.. it would b great if would have also shown how to select entire data...

Hello!
Can you please tell me what formula to use for reading values (numbers) from the last 10 rows in a column? Periodically is added manually one row în the same column, so the formula would read each time the last 10 rows.
Thank you.

Arrays are great but how do I copy the whole matrix?

brilliant explanation, i just wish someone had explained this to me years ago as you have done today, finally i get it. lol

good explanation I wow understand better how to find last cell in column. However I have a slightly different issue and I am very new to vb(I know nothing). I wrote this code which seems to works but is very crude and not efficient, because it is cumbersome. Is there a way to rewrite it so I don't have to make the code so long? A statement to check all the range of that row?
If Range("N9").Value = False Then
Range("N9").Value = Range("D5").Value
ElseIf Range("O9").Value = False Then
Range("O9").Value = Range("D5").Value
ElseIf Range("P9").Value = False Then
Range("P9").Value = Range("D5").Value
ElseIf Range("Q9").Value = False Then
Range("Q9").Value = Range("D5").Value
ElseIf Range("R9").Value = False Then
Range("R9").Value = Range("D5").Value
ElseIf Range("S9").Value = False Then
Range("S9").Value = Range("D5").Value
ElseIf Range("T9").Value = False Then
Range("T9").Value = Range("D5").Value
End If
End Sub