excel last used row

Dim rLastCell As Range

Set rLastCell = ws.Cells.Find(What:="*", After:=ws.Cells(1, 1), _
    LookIn:=xlFormulas, LookAt:= xlPart, SearchOrder:=xlByColumns, _
    SearchDirection:=xlPrevious, MatchCase:=False)

MsgBox ("The last used column is: " & rLastCell.Column)
MsgBox ("The last used row is: " & rLastCell.Row)

Add Own solution

Are there any code examples left?

Find Add Code snippet

New code examples in category VBA

VBA 2022-03-27 20:55:02 excel vba check if all substrings in list are in string
VBA 2022-03-27 20:40:39 excel vba set cell value to empty
VBA 2022-03-27 17:05:52 vba simple quote
VBA 2022-03-27 14:30:19 textbox find and replace vb
VBA 2022-03-27 09:10:21 nested if else in vb.net
VBA 2022-03-27 09:10:09 excel vba string to bits
VBA 2022-03-25 02:00:15 vba verticalalignment
VBA 2022-03-24 12:20:06 Excel web scraping
VBA 2022-03-24 10:11:00 excel vba BitToLong
VBA 2022-03-21 18:00:05 excel vba save file txt

Create a Free Account

Unlock the power of data and AI by diving into Python, ChatGPT, SQL, Power BI, and beyond.

Develop soft skills on BrainApps

Complete the IQ Test

Relative searches

how to get last row last cell value in excel excel last row excel formula to get last row with data find last row with data excel how to go last row in excel last filled row in excel lastcell = page last row in excel how to set the lastcell is last row in page excel find the last row of excel sheet last row number in excel excel how to get last row of table excel get last row in table column excel find last cell in row with value get last row in excel with content get last row in excel excel last value in row excel macro last row excel formula find last row of data last row with data in excel find last row with data in excel using formula excel formula to find last row number with data How to get the last edited or added row in excel get last row value excel find last filled row in excel how to select till the last row in excel get last value from each row excel excel formula to find last row with data excel find last row with specific value excel find last row with data select last 100 rows excel EXCEL LOOKUP LAST ROW VALUE excel select last row with value excel get last row in column get value from last row excel excel last value in row excel find cell get last row and first select column till last row excel how to get to the last row in excel excel find last cell with value in row how to find last row in excel using formula find the last row with data in excel excel get last row name box excel get last row excel return last text in row excel return last value in row last row value in excel excel get last word in row in ms excel what is last row excel select last value in row excel find last row select till last row excel how to get last row in excel how to get the last value in a row in excel how to find the last from description in excel last row in excel excel last row with data EXCEL FIND LAST ROW IN TABLE find last value in a row excel select data for table till last row in excel excel get last row with value excel formula last row last row and column number in excel Excel Select to last row is the last name of the rows in the Excel sheet is the last roll number of the rows in the Excel sheet select last column in table using vba excel last used row

excel last used row

Welcome Back!

Create a Free Account