I am assigning the result of a vlookup to a variable that is defined as Variant. I then need to use that variable in a calculation.
This fails with a run 13 type mismatch
Please Login or Register to view this content.
So how do I use x in a calculation?
Last edited by jartzh; 06-02-2009 at 05:05 PM.
Hello jartzh,
If the value is not found by VLookup then it returns an error. A Variant can be hold a worksheet error which is not an integer. The function will error if the contents of B335 can not be assigned to an integer value. You should check that the value before you attempt to add the numbers. I have change the code to check that the number is an integer.
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
That did it. Thanks a bunch Leith.
Hey Leith,
One little thing.
Msgbox shows the value as 312.2 (which is valid, its $312.20).
but the check for decimal doesnt find it:
never shows that msgbox . So it doesnt consider 312.2 as a vbdecimal. I tried vblong,vbshort...Please Login or Register to view this content.
Any ideas?
vbDecimal is not what you think; see Help for Decimal data type and VarType Constants
Try vbDouble.
Last edited by shg; 06-02-2009 at 04:16 PM.
Entia non sunt multiplicanda sine necessitate
Shg,
Got it . Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks