How can I get the last used column in a sheet???

  • Thread starter Thread starter monika
  • Start date Start date
There's an example on the "Last Row/Col in Worksheet" page on my website
 
One might use the UsedRange property of the worksheet.
This is the range that has been used, but is only
refreshed on saving & re-opening. It is useful though.

The UsedRange has two properties. Columns.Count and
Rows.Count that return the UsedRange width and
height...ie columns and rows. BUT you need to know where
the UsedRange starts, so you'll need the Column and Row
values too.

So, on a spreadsheet...

With Activesheet.usedRange
LastRowUsed = .Row + .Rows.Count -1
LastColumnUsed = .Column +.Columns.Count -1
End With

Patrick Molloy
Microsoft Excel MVP
 
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

Paste in column B using Last row of either column B, C or D. 10
Last Column 5
Return last row no. of column with blanks at top 7
When found add it to the last and display total in Msgbox 23
Copy .Areas.Item(1,2,3,4,5, etc.) to a column or a row 5
Count the columns from one sheet and paste it in another sheet 0
enter key behavior - by sheet 4
Copy columns and paste with blank column between 5

Back
Top