| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to loop by chaning the cell reference?
Hi, I'm trying to do a loop to add names for each column by using the
following formula. As such, the "C5" in "R1C5" will probably need to increase from 5 to a previously determined number. Would like seek expertise how I can loop through this formula effectively. Thank you very much! ActiveWorkbook.Names.Add Name:="C5", RefersToR1C1:= _ "=OFFSET('Wfr Lvl'!R1C5,1,0,COUNTA('Wfr Lvl'!C5)-1,1)" |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hyperlinks are chaning | Excel Discussion (Misc queries) | |||
| Change cell value without chaning formula | Excel Discussion (Misc queries) | |||
| Formula help, chaning a cell number within the formula | Excel Discussion (Misc queries) | |||
| reference 2 arrays in a For Loop | Excel Programming | |||
| Excel VBA Loop & Variable Reference | Excel Programming | |||
Threaded Mode
