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 strongm 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
Apr 24, 2001
26
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
Delete a Table Row in a Filtered Table 2
Replies
11
Views
428
SkipVought
S
remeng
  • Locked
  • Question
Delete dynamic table rows without removing password protection
Replies
7
Views
250
remeng
remeng
sal21
  • Question
scrping in listbox in a web page
Replies
0
Views
204
sal21
sal21
dgillz
  • Locked
  • Question
Back coloring an entire row if a duplicate is found in a dynamic range 1
Replies
18
Views
328
SkipVought
S
remeng
  • Locked
  • Question
Row count for table after filtering
Replies
8
Views
821
remeng
remeng

Part and Inventory Search

Sponsor

Back
Top