excluding text entries in calculations
 

I have the template with macros doing calculations. It is working fine but
when users will enter space which is not visible to correct it is giving
errors and I have to find out where users entered them. They may enter one or
few spaces. What I am looking for is to exclude in calculations those cells
which do not have values but spaces. Is it possible to do that ? How ?

Thanks for help.

Tony

excluding text entries in calculations
 

Put in an IF CLAUSE to limit your calculations to cells havin
values.This will do the trick:

If Isnumeric(c) Then
code
end if

where c denotes cel

--
david
-----------------------------------------------------------------------
davidm's Profile: http://www.excelforum.com/member.php...fo&userid=2064
View this thread: http://www.excelforum.com/showthread.php?threadid=38075

excluding text entries in calculations
 

Thanks for advice.

Tony

"davidm" wrote:


Put in an IF CLAUSE to limit your calculations to cells having
values.This will do the trick:

If Isnumeric(c) Then
code
end if

where c denotes cell


--
davidm
------------------------------------------------------------------------
davidm's Profile: http://www.excelforum.com/member.php...o&userid=20645
View this thread: http://www.excelforum.com/showthread...hreadid=380753