Excel - Select Last 25 Records
Solved/Closed
Wato89642b
-
Oct 10, 2011 at 07:52 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Oct 10, 2011 at 09:49 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Oct 10, 2011 at 09:49 AM
Related:
- Excel - Select Last 25 Records
- Vba select case like - Guide
- Excel free download - Download - Spreadsheets
- Excel marksheet - Guide
- Number to words in excel - Guide
- How to take screenshot of selected area in excel - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Oct 10, 2011 at 09:49 AM
Oct 10, 2011 at 09:49 AM
Hi Wato89642b,
You didn't mention any range, so I'm guessing you want to select the last 25 rows.
Assuming that column A is filled with data.
Try this macro:
Best regards,
Trowa
You didn't mention any range, so I'm guessing you want to select the last 25 rows.
Assuming that column A is filled with data.
Try this macro:
Sub Last25Rows() Dim sRow As Integer Dim lrow As Integer sRow = Range("A" & Rows.Count).End(xlUp).Offset(-24, 0).Row lrow = Range("A" & Rows.Count).End(xlUp).Row Range(Rows(sRow), Rows(lrow)).Select End Sub
Best regards,
Trowa