| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change defined name ranges simultaneously
Hello....
I have a defined name range "SWP" that currently refers to cells A22:D34. However, I need it to update to read A27:F39. This name range is used in about 75 spreadsheets, however it looks like I have to change SWP manually for each spreadsheet. Does anyone have a macro to help change this range or an easy way to update this? Thank you!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can multiple spreadsheets be linked to change simultaneously? | Excel Discussion (Misc queries) | |||
| have to change all the comments in the sheet simultaneously | Excel Discussion (Misc queries) | |||
| Auto change defined name ranges on Jan 1st annually | Excel Worksheet Functions | |||
| defined name ranges | Excel Programming | |||
| Simultaneously change values in multiple cells? | Excel Worksheet Functions | |||
Threaded Mode
