Forum Discussion

Copper Contributor

Jul 14, 2017

Excel 2013 Resource Issues

I have a spreadsheet with 4 worksheets (worst case 15 columns). One worksheet (WS1) contains a copy of data received from a vendor (database dump). Via VB, one column is copied to column A for ...

Excel Desktop

Formulas & Functions

Wyn Hopkins

MVP

Jul 15, 2017

Hi Maureen

There's quite a lot happening in your scenario and it may be difficult for people to help via the forum.

However, one quick question is does your VB code turn calculations and screen updating on and off

Sub Example()


Application.Calculation = xlCalculationManual
Application.ScreenUpdating = False

'code
'...>


Application.Calculation = xlCalculationAutomatic
Application.ScreenUpdating = True

End Sub