Copied Formulas Not Working

J

jigsaw

I have used code to duplicate 2 sheets 26 times each. Within in this
code i use a search & replace function to link the sheet to the
previous week's sheet.

The copy works fine, the formulas look fine. However, the totals from
one week are not carried through to the next week. I have to manually
select the formula and press ENTER.

Each sheet has approximately 30 linked formulas.

Could someone please suggest a way that doesn't mean I have to
manually go through all 52 sheets and re-confirm the formulas.

Thanks
Julie
 
R

Roger Govier

Hi Julie

Did you switch Calculation Mode to Manual in your code, and forget to set it
back to Automatic?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sheet name changing dilemma 2
Insert Row also adds formulas and moves cursor 2
Copy adjacent Sheet and name from a list 42
Code to Insert rows and copy formulas 3
Renaming a copied sheet programatically 3
If specific cell is not empty, copy (or enter) formulas and format 2
Worksheet copy doesn't copy formulas 3
EXTRACTING ROWS OF DATA/FORMULAS TO CREATE NEW WORKBOOK 1

Top