Reference column by number

L

Legacy 5596

Guest
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?
 

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.
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!
 
Upvote 0

Forum statistics

Threads
1,213,483
Messages
6,113,919
Members
448,533
Latest member
thietbibeboiwasaco

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top