VarType(Cell) for a integer and a demical both are Type Long

Originally Posted by jindon

Do you want to find out the data type?

Please Login or Register  to view this content.

Hey buddy

I know the datatype, it is shown in the "Watch window"
Expression.......Value.................Type
Cell.................. 5 .................... Long
(I require TRUE for this iteration)

on the next iteration
Expression.......Value.................Type
Cell................ 3.5 ...................Long
(I require FALSE for this iteration)

So VarType(Cell) is giving me TRUE for both cases.

Something is wrong.
3.5 is not a Long, it is a Double. Longs are 4 byte integers ( whole numbers with zero decimal places). If you want to test for decimal fractions, maybe
remainder = cell - int(cell)
if remainder =0 then whole number

3.png

5.png


I totally agree with you in theory, but its not what VBA wants to do!
*Both 5 and 3.5 are type "double", which doesn't help, because I need a way to distinguish them (I had hoped "5" would return as a vbInteger 2 and "3.5" would return as a vbDecimal 14)


The above photos show the watch window of the values. Below is the code I am using.
And this link:
https://www.excelforum.com/excel-pro...ml#post4774649
is a copy of my spreadsheet I am using.

Please Login or Register  to view this content.

That's maybe the type of the RETURNED value ,which is 5, from VarType function.

Do a step debug with LocaWindow open, you will see all the variables and types.

Please Login or Register  to view this content.

x = Double
y = Long

.... Still something is wrong...
If you use TypeName(x), it will return "Double" though.

Originally Posted by jindon

Do a step debug.

My understanding of debugging is "press F8 (and use breaks too) and use the watch window until you find something that doesn't work right"

Am I missing something I should know?