calculate varrying formulas
 

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?

calculate varrying formulas
 

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

"mvp4pres" wrote:

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?