I have data in B1 that runs across the entire row, but the last column can vary. How do I count columns to find out the last column in B with data and then add 1 to it? So, if my last cell is Z2, I want to activate AA2 (so I can drop a formula in it). I know how to drop the formula in, I just do not know how to count columns. Here is what I tried.
VBA Code:
Sub TestSelect()
Dim lastcol As Long
lastcol = ActiveSheet.Cells(ActiveCell.Row, Application.Columns.Count).End(xlToLeft).Column
Range(lastcol & "2").Select
End Sub