On Sat, 12 Mar 2005 09:57:44 -0500, "David McRitchie"
wrote:

I expect the second part of the question was answered by now but
rather than going back to the newsgroup, I'll just say to include
a test for being a number. I got sidetracked to try to find out
if the actual cell address of the formula could be determined
(I don't think it can be).

if IsNumeric(c) then SumBold = SumBold + c.Value


I thought of that, but then decided to let the OP make the call. I think one
could make a case that it's important to know if some cells that are supposed
to be numeric are not (e.g. l instead of 1).

If that's not important, one could also do:


SumBold = SumBold + Val(c.Text)

I'm not sure which would be faster, though.


--ron