Excel - Select Last 25 Records
Solved/Closed
Wato89642b
-
10 Oct 2011 à 07:52
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 10 Oct 2011 à 09:49
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 10 Oct 2011 à 09:49
Related:
- Excel - Select Last 25 Records
- Excel mod apk for pc - Download - Spreadsheets
- Vba select case like - Guide
- Kernel for excel repair - Download - Backup and recovery
- Vat calculation excel - Guide
- Canoscan lide 25 driver - Download - Drivers
1 response
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
10 Oct 2011 à 09:49
10 Oct 2011 à 09:49
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