| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing a named range within a formula
I'm trying to set up a macro that will update the reference to a anamed range
within a formula. For example, cell A1 contains a value of "LastName" which also happens to be a named range. Cell B1 contains the formula "=Count(LastName)" When I change the value of A1 to the name of another named range, i.e. "Address", and run the code, I want the formula in B1 to change to "=Count(Address)" Ideas? -- Thanks, Mark |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| changing font color in named range using vba | Excel Programming | |||
| changing font color in named range using vba | Excel Programming | |||
| Copying a named range with a changing cell reference | New Users to Excel | |||
| Changing graph axes using named range | Excel Programming | |||
| Changing graph axes using named range | Charts and Charting in Excel | |||
Threaded Mode
