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: 674

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?



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.