| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Column letter reference as number reference
I use the below to get the vertical edge of the print area.
Range("Print_Area").Address The output of this is something like "$A$:1$AZ$57". I would like to run a macro that checks each cell in a row from column "A" to (as in the above) column "AZ" I would like to use something like For col = 1 to 52 How do you represent AZ as 52? Or is there a better way of doing this? (I'm sure there is) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reference a number from a different column in a formula | Excel Worksheet Functions | |||
| Extract Column Letter from Cell Reference in another Cell | Excel Discussion (Misc queries) | |||
| Reference a Column by Number | Excel Programming | |||
| Selecting a range using a column number reference | Excel Programming | |||
| reference to column (not known) and certain row number | Excel Programming | |||
Threaded Mode
