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?