Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
apply all names
Hi there,
Objective: - raplace cell references with names Question: - Is it possible to apply all the defined names without having to select them one by one in the Apply Names dialog box? Thank you |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
apply all names
Here's something to get you started...
Sub NamesLoop() Dim N As Name Dim strIN As String Dim strOUT As String For Each N In ActiveWorkbook.Names strIN = N.RefersTo '---------------------------------------------------------- ' strIN will be in a form something like - "=Sheet1!R1C1" ' Here you need to parse strIN, make your change and put _ the result into strOUT '---------------------------------------------------------- N.RefersToR1C1 = strOUT Next N End Sub HTH NickH |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Apply names to relative references | Excel Worksheet Functions | |||
Excel should apply names in all worksheets of a workbook | Excel Discussion (Misc queries) | |||
How do you apply Names in formulas? | Excel Discussion (Misc queries) | |||
Selecting ALL names when using Insert/Names/Apply | Excel Worksheet Functions | |||
One More Try: Names/Apply on other worksheet | Excel Worksheet Functions |