VB V's Excel
 

Hi

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

pd


--
pcd
------------------------------------------------------------------------
pcd's Profile: http://www.excelforum.com/member.php...o&userid=29557
View this thread: http://www.excelforum.com/showthread...hreadid=492595

VB V's Excel
 

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


---
Regards,
Norman


"pcd" wrote in message
...

Hi

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

pd


--
pcd
------------------------------------------------------------------------
pcd's Profile:
http://www.excelforum.com/member.php...o&userid=29557
View this thread: http://www.excelforum.com/showthread...hreadid=492595

VB V's Excel
 

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

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


- -Mark

"pcd" wrote:


Hi

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

pd


--
pcd
------------------------------------------------------------------------
pcd's Profile: http://www.excelforum.com/member.php...o&userid=29557
View this thread: http://www.excelforum.com/showthread...hreadid=492595