calculate varrying formulas

M

mvp4pres

I created a macro that goes through a range of cells (b6:b40) calculating the
formula that is in that cell. The formula changes from week to week, but
when I use the macro I created it always gives me the results of the formula
I used when I first created the macro.

any help or ideas?
 
K

kassie

You don't show your code, but my guess is your macro inserts a specific
formula in these cells?
 
Top