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 January 16, 2023 - Oct 10, 2011 at 09:49 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Oct 10, 2011 at 09:49 AM
Related:
- Excel - Select Last 25 Records
- Excel date format dd.mm.yyyy - Guide
- Vba select case like - Guide
- Transfer data from one excel worksheet to another automatically - Guide
- Number to words in excel - Guide
- Screenshot in excel - Guide
1 reply
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
544
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