macro which finds last cell in a column

  • Thread starter Thread starter vikram
  • Start date Start date
V

vikram

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

thank
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel macro code for copying data to a cell reference which is set byvalues in two separate cells in 3
Number series at end of column macro? 4
Moving a bunch of data 1
VBA set thick borders around non empty cells in range 0
Excel Macro to automatically go to the right of the last colored cell 0
select last column and last nonblank cell 4
Need help with an excel macro to group & outine rows 0
Inserting cells (shift cells right) using macro 0

Back
Top