select cell in row 3 of (lastColumn)+1

[Shakeable_Drip]

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.

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

 

[FlashDota]

What I usually do is use relative reference here. Try recording the macro. Select A1 (whatever cell), ctrl down to get to the last cell, turn on relative reference, go down one cell. Then if you need to write something in it you can use ActiveCell

 

[DanteAmor]

I'm trying to select the cell after last column

I am adding +1 to select the next cell after the last cell with data.

Sub LastColumn()
  Dim sht As Worksheet
  Dim LastColumn As Long
  
  Set sht = ActiveSheet
  
  LastColumn = sht.Cells(3, Columns.Count).End(xlToLeft).Column + 1
  sht.Cells(3, LastColumn).Select
End Sub

 

[Joe4]

Change this line:

sht.Range(LastColumn & "3").Select

to this:

sht.Cells(3, LastColumn + 1).Select

 

[Shakeable_Drip]

both answers worked thanks!

 

[Joe4]

You are welcome. Glad we were able to help.

Yep, the two code answers are very similar. It is just a matter of when you want to add the one - in the calculation, or in the select statement.
It doesn't really make a difference which one you use.
If you were to use this "LastColumn" variable field in multiple lines of code, then it might save you a little bit of typing to add it to the calculation, like Dante shows. It will save you a few keystrokes.

 

[Shakeable_Drip]

You are welcome. Glad we were able to help.

Yep, the two code answers are very similar. It is just a matter of when you want to add the one - in the calculation, or in the select statement.
It doesn't really make a difference which one you use.
If you were to use this "LastColumn" variable field in multiple lines of code, then it might save you a little bit of typing to add it to the calculation, like Dante shows. It will save you a few keystrokes.

Thanks! and yes my intent is to carry the same variable in multiple places. I'm posting another question about organization in a few moments. I think I have all the Pieces for my project, but I think my organization is wack, as I'm a super Newbie. I can probably bash my way to the goal from here but I'd love it to be clean and organized.