Checking user has input a valid address.  
Author Message
AndrewNettles





PostPosted: Tue Mar 07 16:57:51 CST 2006 Top

Excel Programming >> Checking user has input a valid address.



Excel325  
 
 
Dave





PostPosted: Tue Mar 07 16:57:51 CST 2006 Top

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.



--

Dave Peterson