Screenupdating not working
While I’m thinking about this stuff, I’d like to share a few simple tips for speeding up your Excel VBA code. So feel free to comment and share any other performance tips you may have.Each time a cell that affects any formula in your spreadsheet is changed or manipulated, Excel recalculates the entire worksheet.
That is to say, the status bar will continue to be updated even if you disable screen updating. Display Status Bar property to temporarily disable any status bar updates, further improving the performance of your macro.
Clear Contents Dim obj Outlook_Approver As Object Dim Obj NS_Approver As Object On Error Resume Next Set obj Outlook_Approver = Create Object("Outlook.
Range("N6") = semail_Approver End End If Sheets("Background").
The status bar normally displays the progress of certain actions in Excel.
For example, if you copy/paste a range, Excel will show the progress of that operation on the status bar.