Issue using IsNumeric to identify number in cell or array element

[welchs101]

Hi,

i am enclosing a macro. Basically, i create an array in the macro from A1 to A10. I then test the array contents which came from cell A2........where cell A2 is blank. For some reason the array value extracted from cell A2 IS numeric.........but why?

Any idea?

Since ISNUMERIC does not seem to do what i want any recommendations on what to do.........i dont want to trim value before storing into array because then values in array will be treated as text i think.

any good ideas?

[jindon]

Please Login or Register  to view this content.

[Leith Ross]

Hello welchs101,

It happens because the cell is Empty. In VBA this ndicates that no beginning value has been assigned to a Variant variable. An Empty variable is represented as 0 in a numeric context or a zero-length string ("") in a string context.

[jindon]

welchs101

Thanks for the rep.
You shuold be very careful in using IsNumeric function.

It will return True for the data like "1d5" or "1,,,,,5"