View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Dave Ramage[_3_] Dave Ramage[_3_] is offline
external usenet poster
 
Posts: 8
Default last non-empthy cell

Dov,

To simply select the cell:
ActiveSheet.Range("A" & ActiveSheet.Rows.Count).End
(xlUp).Offset(1,0).Select

Or, to get the row number:

Dim lRow as Long
lRow = ActiveSheet.Range("A" & ActiveSheet.Rows.Count).End
(xlUp).Row + 1
Range("A" & lRow).Value = "Next Cell"

Cheers,
Dave
-----Original Message-----
hi, i need to "tell" the macro to move the coursor to the

first empthy cell
in a coloumn, how to do that?

thanks, dov

.