turn Calculation OFF from columnB to BT except column A

  • Thread starter Thread starter alienscript
  • Start date Start date
A

alienscript

Hi the experts,

I have a data worksheet ranging from column A to BT and covering 6880
rows.
I have maintained a few columns in between with Sumproduct and
If(Countif()) formulas.

Whenever I insert columns and vlookup values to other worksheets, the
calculation takes very long.
I only want to leave Calculation ON for Cell A1 and turn Calculation
manually OFF for the rest of the formulas in between column B to column
BT. How am I be able to do that with VBA code ??

Formula in Cell A1 is the items-counter only.
A1=SUBTOTAL(9,C2:C6880)

I would be very very grateful if someone can help me on this matter.
Thanks so much in advance!
 
Not exactly - and the "cure" might be more trouble than the symptoms.

You can set calculation to Manual and run a macro to calculate *only*
specific worksheets/ranges etc. In your case something like :-

ActiveSheet.Columns("A").Calculate
 
You must be Lord! You saved me all the stressful hours at work...

I am glad you answered. Thank you very very very much
 

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

Help with a COUNTIF formula 2
Turn on/off calculation in worksheet 4
To give paste special (value) in macros 1
Ignore calculation when criteria exceeds 12 5
Retrieving the Column name (e.g. BT) from a numeric 3
Making a spreadsheet calculate faster 4
Using Sumproduct - Excel 2003 3
VBA calculate avg dates 1

Back
Top