How can I let the macro determine if the contents of a cell is numeric or text

[NALDO]

Hello everyone,

i need a help on this one.... I encoded a macro that will simply get the difference of the two column with the use of "DO" and "LOOP" function. But if the cell contains a text data it generates an error and stops the macro. here is my macro:

Please Login or Register  to view this content.

How should it appear if i want that the formula will continue until cell.offset(0,-1).value = "" even if along the way there is an error (in this case there is a text data in the cell)?

Thanks!

[nilem]

try it

Please Login or Register  to view this content.

[NALDO]

this works perfectly great!!!! thanks!!!

[NALDO]

but why if i run this macro using Office 2003 the result is "#NAME?"? do we have any work around for this?

[nilem]

Please Login or Register  to view this content.

[NALDO]

Thanks man! you're the best.. where can i find the explanation for this formula? i want to understand the logic behind this statement... thanks!

[nilem]

Just remove this line

Please Login or Register  to view this content.

and you can see very simple formulas in a worksheet

[NALDO]

now i get it... thanks!