Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Checking user has input a valid address.
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Checking user has input a valid address.
dim teststr as string
dim testrng as range teststr = "hi there" 'get it someway set testrng = nothing on error resume next set testrng = activesheet.range(teststr) on error goto 0 if testrng is nothing then 'it's not a range else 'yep it is end if You may want to look at application.inputbox(....,type:=8), too. Peter Rooney wrote: -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
checking hyperlinks are valid | Excel Discussion (Misc queries) | |||
The address of this site is not valid. Check the address and try | Excel Discussion (Misc queries) | |||
checking hyperlinks are valid | Excel Discussion (Misc queries) | |||
Checking for valid date | Excel Programming | |||
Pause macro for user cell address input | Excel Programming |