I'm trying to get VBA to select a range from G8 to the last used cell in column A. I can get the row for the last cell with
How do I combine the row value with A to select the range I want? my best guess is something like
I'm not sure how to format the indirect cell reference in VBA, and it's obviously wrong here. Any tips?
Thanks
Code:
Cells(Rows.Count, 1).End(xlUp).Row
Code:
Dim ws As Worksheet
ws = Worksheets("sheet")
Dim C As Long
C = Cells(Rows.Count, 1).End(xlUp).Row
ws.Range(A & C:"G8").select
Thanks