Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Detect Last Row in Table

Status
Not open for further replies.
inf33323

inf33323

Technical User
Joined
Apr 24, 2001
Messages
26
Location
DE
Hi,

is there any method that retrieves the last row in a workbook?

Thanks in advance.
 
Sort by date Sort by votes
You can use:

ActiveCell.SpecialCells (xlCellTypeLastCell) or
ActiveCell.End (xlDown)
Store300

Store300@ftnetwork.com
 
Upvote 0 Downvote
To actually get the row number, you would need to do something like this:

Code: 
ActiveSheet.Cells.SpecialCells(xlCellTypeLastCell).Row
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

MattGreer
  • Locked
  • Question Question
Delete a Table Row in a Filtered Table
Replies
11
Views
2K
SkipVought
S
remeng
  • Locked
  • Question Question
Delete dynamic table rows without removing password protection
Replies
7
Views
873
remeng
remeng
2009luca
  • Locked
  • Question Question
put value in input box web page
Replies
0
Views
401
2009luca
2009luca
sal21
  • Locked
  • Question Question
scrping in listbox in a web page
Replies
0
Views
758
sal21
sal21
Andrzejek
  • Locked
  • Question Question
Hyperlinks in Word cut at #
Replies
2
Views
712
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top