Shakeable_Drip
Board Regular
- Joined
- May 30, 2023
- Messages
- 52
- Office Version
- 365
- Platform
- Windows
I'm trouble shooting a portion of my VBA and I recieve the error: method 'range' of object'_worksheet' failed.
I'm trying to select the cell after last column, but I seem to select the cell in the last column.
I'm trying to select the cell after last column, but I seem to select the cell in the last column.
VBA Code:
Sub LastColumn()
Dim sht As Worksheet
Dim LastColumn As Long
Set sht = ActiveSheet
LastColumn = Cells(3, Columns.Count).End(xlToLeft).Column
sht.Range(LastColumn & "3").Select
End Sub