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