Excel Setting problem ? ? ?

  • Thread starter Thread starter JVS
  • Start date Start date
J

JVS

I was working on a macro using
Application.ScreenUpdating = true & false
I know that I have the last line of the macro with it set to "true".

But now when I copy a formula to several other cells in the same column I do
not get the correct answer until "after" I save the work sheet. It does not
matter what sheet I'm working in, even a new sheet with no macros.

I think that I have a setting turned off but not sure how to reset it.

(The formula is as simple as cell A1 "=C1" so it's not a formula error.)

Help!


Thanks
jvs
 
Sounds like you have calculation set to manual

tools=>Options=>Calculation tab, set to automatic
 
You must log in or register to reply here.

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

Run two macros for two different sheets 11
OnTime Change_Event macro AND copy to sheet2 macro trouble 7
Excel VBA help: Text file formatting 19
File not found: VBA6.DLL 2
Workbook_BeforeSave 8
Runtime error 1004 when trying to insert formula in cells 11
Code execution is correct but generates Error :The file you aretrying to open is in a different form 3
Modify Claus code "Sub Array_Var_Column_Sort()" 27

Back
Top