I created a macro that creates a new sheet in my workbook. It copies a sheet that has formulas already on it. The problem is- after the new sheet is created the formulas don't work. Everything gets copied like it is suppose to but the forumals won't calculate. Does anyone know why this would happen? Do i need to add something to the code tyo refresh the sheet?!!!
1. Has Calculation been set to Manual? Tools > Options > Calculation (tab). Click on Automatic.
2. If the formulas are set to reference the same as the original worksheet, then there is no "re-calculation" unless you change the underlying data. Is that what you want? Or do you have difference references that need to be made?
old, slow, and confused
but at least I'm inconsistent!