SanjayGMusafir
Well-known Member
- Joined
- Sep 7, 2018
- Messages
- 1,513
- Office Version
- 2024
- Platform
- Windows
Hi Experts
Here arrives a new problem. I copy pasted a vba from 1 sheet to another. The earlier sheet it was doing fine as there was only one table in that sheet. Now the problem is that current sheet has many tables and I want it to go to the last row of current table in the current column. Please help. Thanks a lot
Here arrives a new problem. I copy pasted a vba from 1 sheet to another. The earlier sheet it was doing fine as there was only one table in that sheet. Now the problem is that current sheet has many tables and I want it to go to the last row of current table in the current column. Please help. Thanks a lot
Code:
Dim lRow As Long
Dim lCol As Long
lRow = Cells(rows.Count, 1).End(xlUp).Row
lCol = ActiveCell.Column
'To go to last row of the same Active column
Cells(lRow, lCol).Select