last row

  • Thread starter Thread starter larry
  • Start date Start date
L

larry

is it possible to get the last row of a range,

where the range spans several columns of data?
 
try
lastrow = Sheets("Sheet12").Cells.Find("*", searchdirection:=xlPrevious).Row
MsgBox lastrow
 
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
End process at last row of data 3
VBA set thick borders around non empty cells in range 0
Return last row no. of column with blanks at top 7
Everchanging number of rows 3
Loop from left to the right 5
Row and column count last occupied cells in range 2
Import multiple workbooks to current workbook in specified row number 0

Back
Top