Logo 
Search:

MS Office Forum

 Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Retrieving the Type of a Variable

  Asked By: Madeleine    Date: Nov 14    Category: MS Office    Views: 673
  

I'm using Excel 2000. Last week, while working on this project, I
know I was able to easily print out the type of a variable using
MsgBox (for debugging purposes). However, I can no longer remember
what the command was! Can anyone help me with this?

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Daya Sharma     Answered On: Nov 14

I think the function you want is TypeName... which returns a literal
specifying the type  of a variable. You can see quite a bit more in Help.

 
Didn't find what you were looking for? Find more on Retrieving the Type of a Variable Or get search suggestion and latest updates.




Tagged:      

 
 
 
 

Related Post