Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro changing region names
Hi,
I have a workbook with multiple tabs. All tabs have a defined names region. For example if a tab is named 401 there is a name in the tab for 401 = A1:P400. I would like to change the region selection all at once so it will change to 401= A1:Z400. I would like to use a macro to change regions for all the tabs rather doing this manually one by one. Your help is truly appreciate it. Thanks in advance Nikki by one. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Paste values all cells in a region which refers to out of region | Excel Worksheet Functions | |||
how to find used region with macro | New Users to Excel | |||
Changing worksheet names | Excel Worksheet Functions | |||
changing file names | Excel Discussion (Misc queries) | |||
Error opening a CSV from Web Browser after changing Region | Excel Discussion (Misc queries) |