Reference column by number

[Legacy 5596]

Ok, imagine Excel didn't have column letters, and you simply had x,y
x= column, y=row.
Now, I know the column I want is column 7 (which is column G)and that I want the data from rows 3 thru 62.
Normally I could do G3:G62
But using the premise that I only know the number of the column, how can I do the same thing as G3:G62?

 

[Barry Katcher]

Bears 1, ferrets 0. Sob!

 

[Legacy 5596]

Yea it functions great, pulling call center data:
BREAKDOWN
The result is to know how many CSRs needed at any given hour based on accepted abandon rate of calls, figuring in how many calls are expected that given hour. I roundup so that the numbers match data being precisely accessed in the other sheets.

P.S. -- Barry -- Your code would have worked if I'd used the option from the beginning. It was just too difficult for me to think in r1c1 mode. But thanks!