Macro to add cell value to referring cells formula
 

Hi, I am trying to build a macro that adds 1 months
depreciation to a cell everytime it runs.

= 7.85 + 7.85 + 7.85 is how the result should look.

Something like:

Search A:A

If Cell in Column A Isnumber

Add (+)Cell Value to end of formula in same cell # in
Column B


Any ideas how to approach this?


Thanks,

Todd.
..