Thread: Extracting data type from variable
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ExcelMonkey[_183_] ExcelMonkey[_183_] is offline
external usenet poster
  
Posts: 1
Default Extracting data type from variable

Is is possible to extract the data type of a variable? For example let
say I have two variables X and Y

Dim X as Comment
Dim Y as Range

I now want to evalute what data type X is. Is their a property fo
type?

IF X.Type = Comment Then

et

--
ExcelMonke
-----------------------------------------------------------------------
ExcelMonkey's Profile: http://www.excelforum.com/member.php...nfo&userid=522
View this thread: http://www.excelforum.com/showthread.php?threadid=27680

Reply With QuoteReply With Quote