Checking user has input a valid address.
Index
‹
Excel
‹
Excel Programming
Author
Message
AndrewNettles
Posted: Tue Mar 07 16:57:51 CST 2006
Top
Excel Programming >> Checking user has input a valid address.
Excel325
Dave
Posted: 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
Index
‹
Excel
‹
Excel Programming