Last used cell

  • Thread starter Thread starter Hawk
  • Start date Start date
Hi
for column A try
ActiveSheet.Cells(Rows.Count, "A").End(xlUp).select
 
GetBottomRow = TheSheet.Cells.Find(what:="*", SearchOrder:=xlByRows, _
SearchDirection:=xlPrevious).Ro
 
I suggest using worksheet.usedrange.columns.count and usedrange.rows.count
You can then use worksheet.cells to refer to it.
Geoff
 
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

VBA set thick borders around non empty cells in range 0
Count latest number of continous not-empty cells in a row. 11
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
End of rows in a column 1
Excel VBA 1
LAddress of last cell in worksheet 3
Simple Macro to Auto fill Cells 1
Copy a range data from 1 sheet to multiple selected sheets 1

Back
Top