Number problem 1

[airtabaki]

Probably it's been written before in here but I don't seem to find any that has to do with my little problem.

I've written a macro that will make a sum of certain columns. Now when there is one value that is not a number the macro will crash. Is there an easy way to test of the data are all numbers?

I've thought of the solution Val(), but that I find a bit dangerous. In this way it can happen that you make a typing mistake and without knowing it it will be changed in a number, so you get wrong data.

 

[ETID]

Highlite the columns in question...


then from menu select... Data>Validation

set "Allow" to either whole number or decimal (your choice)

then "Data" as greater than or equal to zero



...this will stop users from fumbling keys when they enter data

 

[airtabaki]

thanks a lot ... I didn't thought that it was that easy

 

[dcompto]

Thanks from me, too, and a star.