Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find invalid names via VBA
Using VBA, how do I identify invalid dynamic range names?
For Example, I would like the following to be flagged: "TargetRng" is defined as OFFSET(StartPoint, 0, 0, 1, 100) where "StartPoint" is undefined. Thank you for your help |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find invalid names via VBA
Dim rng as Range
On Error resume Next Set rng=Range("TargetRng") On Error Goto 0 If rng is Nothing then MsgBox "Error" Else Whatever Endif HTH -- AP "efree" a écrit dans le message de news: ... Using VBA, how do I identify invalid dynamic range names? For Example, I would like the following to be flagged: "TargetRng" is defined as OFFSET(StartPoint, 0, 0, 1, 100) where "StartPoint" is undefined. Thank you for your help |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find invalid names via VBA
Ardus Petus wrote: Dim rng as Range On Error resume Next Set rng=Range("TargetRng") On Error Goto 0 If rng is Nothing then MsgBox "Error" Else Whatever Endif HTH -- AP "efree" a écrit dans le message de news: ... Using VBA, how do I identify invalid dynamic range names? For Example, I would like the following to be flagged: "TargetRng" is defined as OFFSET(StartPoint, 0, 0, 1, 100) where "StartPoint" is undefined. Thank you for your help Thanks for that. Almost there... In adapting the methodology to my workbook at large, via: For Each n In ActiveWorkbook.Names .... Next Along with invalid dynamic ranges, the subroutine flags all of the names defined for formulas because, strictly speaking, those do not refer to ranges. For example: "oftenUsedFormula" - name defined as COUNTIF(A1:A500, "< 6") Any thoughts? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
invalid names were detected in this workbook | Charts and Charting in Excel | |||
Invalid define names | Charts and Charting in Excel | |||
Invalid Names | Links and Linking in Excel | |||
Renaming Invalid Defined Names | Excel Programming | |||
Invalid Range Names | Excel Discussion (Misc queries) |