I am using Excel 2007.

It seems so simple, but I can't piece together the last line of code. I'm drawing a blank for some reason.

Code:
'Stores the number of the last row
Range("G1").Select
Selection.End(xlDown).Select
intLastRow = ActiveCell.Row

'Stores the number of the last column
Range("G1").Select
Selection.End(xlToRight).Select
intLastColumn = ActiveCell.Column
What I'm trying to do is select the entire group range. I tried using...

Range("G1", ????).select

The problem here is if I use intLastColumn it'll give me the # of the column (Ex. A = 1, B = 2, C = 3, etc). I need the letter so I can put...

"P" & intLastRow

...in orde to select the entire group. Is there a way to Convert the number back to the column letter or even store the Column letter rather than the #?