| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Checking reference for named cells
If I have several named cells in say 10 worksheets, and I delete sheet 8,
then I have some named ranged left out there with no valid reference. How can I check the validity of a named cell in vba? I have this so far... Sub test() Dim Nam As Name For Each Nam In ActiveWorkbook.Names "Place code here to check if reference on name is good, if it isnt then delete that name." Next Nam End Sub Thanks in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Checking for non-blank cells in named range | Excel Programming | |||
| Checking for non blank cells in named range | Excel Programming | |||
| Checking for non-blank cells in named range | Excel Programming | |||
| 3 cells are named together - how refere to them in one chart reference field (a seriescollection(1) ) | Excel Programming | |||
| 3 cells are named - how to refere to them in one reference field in a chart | Charts and Charting in Excel | |||
Threaded Mode
