Hi everyone
Im trying to make a selection from a specific cell untill the last row and last column of the sheet. I have the letter of the last column which is "DS'' but now i want to use this in my range selection.
Anyone knows the answer?![]()
Sub Example() LastRow = Cells(Rows.Count, "B").End(xlUp).Row LastCol = Cells(1, Columns.Count).End(xlToLeft).Column ColumnLetter = Split(Cells(1, LastCol).Address, "$")(1) Range("G3:DS" & LastRow).Select End Sub
Bookmarks