SanjayGMusafir
Well-known Member
- Joined
- Sep 7, 2018
- Messages
- 1,503
- Office Version
- 2021
- Platform
- MacOS
Hi Experts,
I got the underneath VBA from this forum itself. It was (is) working fine. But recently to make my work faster, I have added few blank rows at the bottom. Number of blank rows to my structured table keep varying depending upon how many I used and how many I may randomly add.
So can there be some improvement in VBA to skip the blank rows and go to the last active row of the table.
Just to help, if it may, the rows that I add to the table are automatically filled with table formulae, which give Blank value until I input some data in Column H
Thanks in advance
Much appreciated
I got the underneath VBA from this forum itself. It was (is) working fine. But recently to make my work faster, I have added few blank rows at the bottom. Number of blank rows to my structured table keep varying depending upon how many I used and how many I may randomly add.
So can there be some improvement in VBA to skip the blank rows and go to the last active row of the table.
Just to help, if it may, the rows that I add to the table are automatically filled with table formulae, which give Blank value until I input some data in Column H
Thanks in advance
Much appreciated
VBA Code:
Sub GoClientsBottom()
'
' GoClientsBottom Macro
'
'
Sheets("Client").Select
'To reset Zoom levels of the sheet
Call ZoomReset
Dim LRow As Long
Dim LCol As Long
LRow = Cells(Rows.Count, 1).End(xlUp).Row
LCol = ActiveCell.Column
'To go to last active row of the same Active column
Cells(LRow, LCol).Select
If ActiveCell.HasFormula Then
Exit Sub
Else
ActiveCell.End(xlUp).Select
Range(ActiveCell.Offset(1, 0), ActiveCell.Offset(1, 0)).Select
End If
'ActiveWorkbook.Save
End Sub