Thread: Check if variable is range
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Michiel via OfficeKB.com Michiel via OfficeKB.com is offline
external usenet poster
  
Posts: 48
Default Check if variable is range
Hi Dave,

I was right, it is indeed very simple.
Thank you very much. This will do!

M.

Dave Peterson wrote:
Maybe you could use:

MsgBox TypeName(vrString)
MsgBox TypeName(vrRange1)
MsgBox TypeName(vrRange2)

To see if that gives you want you need.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/201005/1

Reply With QuoteReply With Quote