VB V's Excel

P

pcd

Hi

The spreadsheet has grown to 10MB.The project has 20+ worksheets tha
calculate many formulas and graphs.The only way to speed up th
calculations was to change back to excel; as the more VB code th
slower the project. Is there a way to use VB and not slow down th
project?

p
 
N

Norman Jones

Hi P,

Knowing nothing of your code it is very difficult to help, but arranging
your code as follows may help:

On Error GoTo XIT

With Application
CalcMode = .Calculation
.Calculation = xlCalculationManual
.ScreenUpdating = False
End With

ActivesheetDisplayPageBreaks = False

'Your code

XIT:
With Application
.Calculation = CalcMode
.ScreenUpdating = True
End With
 
E

exceluserforeman

The vb code should speed things up.

The problem may occur with too many formulas calculating values that never
change. Change the formulas to values.
Assign a macro (message box) to show what these values refer to if need be.

don't use cell colors or large font sizes if you are the only person to view
it.

Columns of colored cells just to make it "pretty" also adds to recalc of the
sheet/workbook


Alternatively, spread the sheets into 20 Workbooks and have anther workbook
to "import data" when it is required, with links to the 20 workbooks.

You need to specify what you do and why. Does anyone else see your work?

You can email me at [email protected]

See my stuff at:
http://www.geocities.com/excelmarksway


- -Mark
 
Top