Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
To to check whether a string is a valid reference
Hiya
I wish to take a string such as ThisString = "'Sheet Name'!$A$1:$C$3" And use it within a range object like so: Set Location = Range(ThisString) This example would work but I wish to avoid errors generated by strings which aren't valid references. Is there a method about which can check whether the string is a valid reference? I'm not too hot on error trapping and generally aim to avoid them in the first place. So I would prefer not to use the On Error statement unless you thoroughly explain it as if I'm very stupid. TIA! Nick |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Zero-Length string vs Zero (also a valid value) | Excel Worksheet Functions | |||
How to check valid Date value? | Excel Worksheet Functions | |||
Valid SQL string | Excel Discussion (Misc queries) | |||
How to check that a string is a valid formula ? | Excel Programming | |||
check for valid file | Excel Programming |