| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding a Range Name
Thanks for all help
James "James Montgomery" wrote in message ... Hi, The code below when finding the Range Name and when the name is exists on the sheet it runs ok but when it does not find the Range Name ("Stop") it blows up with a run time error that reads 'Global Method Failed' Can someone help and show me what is wrong or the proper way to code this. If Not Range(Range("D101"), Range("D65536")) _ .Find(Range("Stop")) Is Nothing Then GoTo NextStep (MyCode) Exit Sub NextStep: (MyCode) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding the corresponding value in a range? | Excel Worksheet Functions | |||
| Finding a value associated with a range | Excel Worksheet Functions | |||
| finding name within range | Excel Worksheet Functions | |||
| finding if name within range | Excel Worksheet Functions | |||
| Finding from a range | Excel Programming | |||
Hybrid Mode
