Assuming the data's in sheet1, this will return the next empty cell in
column A

ThisWorkbook.Sheets("Sheet1").Range("A65536").End( xlUp).Offset(1, 0)

HTH

Alan P.


"Steved" wrote in message
...
Hello from Steved

Please in Column A how do i find the last row with data
using a macro.

At the moment I'm on Row 1108 so can a macro find the next
row in this case 1109 biut by tonight I'll be on row 1150,
so in this case would it goto row 1151.

Thankyou Very Much.