| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help, Urgent Excel Formulas are not calculating | Excel Discussion (Misc queries) | |||
| Problem with named formula's | Excel Worksheet Functions | |||
| calculating formulas for all workbooks in a folder | Excel Worksheet Functions | |||
| Automatic Calculate Worksheets | Excel Worksheet Functions | |||
| Tricky formulas needed | Excel Worksheet Functions | |||
Linear Mode
