macro which finds last cell in a column

[vikram]

please help me by telling a macro which finds last cell in a column

thank

 

[Trevor Shuttleworth]

Dim LastRow as Long
LastRow = Range("A65536").End(xlUp).Row

or if you just want to select it:

Range("A65536").End(xlUp).Select

Regards

Trevor