|
Posted to microsoft.public.excel.programming
|
|
|
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
|