I have this code to select a table without selecting the headers... it comes up with an error...
I just figured out that lascol is a number... is there any way i could bring it back as the column letter?
Rich (BB code):
Sub zselect()
Dim lastrow As Integer
lastrow = Range("A65536").End(xlUp).Row
Dim lastcol As Integer
lastcol = Range("AA2").End(xlToLeft).Column
Range("A1:" & lastcol & lastrow).Select
End Sub
I just figured out that lascol is a number... is there any way i could bring it back as the column letter?