Last Column and Last Row

[Guest]

I'm trying to select from A2, all the way to the last column down to the last
row of the current data set to do some formatting. This code is not working
because I am unable to find a way to select that range once I have last
column and lastrow set. Could I get some assistance with that? THANKS!!!

Dim LastColumn As Long
LastColumn = Range("A1").End(xlToRight).Column
LastRow = Cells(Rows.Count, "A").End(xlUp).Row

' THIS part is incorrect
Range("A2" & LastColumn & LastRow).Select

 

[Guest]

Use cells instead

Range(cells(2,"A"),cells(LastRow,LastColumn)).Select

 

[Guest]

worked perfectly, thanks for that. After some experimenting I came close to
that, but I don't think I would have figured it out anytime soon, that saved
me a ton of time, HA!!! THANKS!!!!