https://community.blueprism.com/t5/Product-Forum/Excel-Macro-Question/m-p/88981#M39445 Don't forget to set Application.ScreenUpdating to true at the end of the macro. I've found it best to include an error handler to re-enable it, in case the macro fails for some reason. Something like this: Sub Macro()     On Error Goto MacroError     Application.ScreenUpdating = False     ' Do macro stuff....   MacroError:     Application.ScreenUpdating = True End Sub   If it still appears to hang, try stepping through the macro with the Excel debugger to see where the hold up is. Fri, 14 Dec 2018 18:56:00 GMT NicholasZejdlik 2018-12-14T18:56:00Z https://community.blueprism.com/t5/Product-Forum/Excel-Macro-Question/m-p/88980#M39444 Hi, I've been using an Excel macro to remove NA/NV rows from my worksheet: '----------------------------------------------------------- ' ExcludeNV - Removes rows with #NA in column D '----------------------------------------------------------- Sub ExcludeNV() Dim lRows As Long, lRow As Long          Application.ScreenUpdating = False     Worksheets("Customer Details").Activate     lRows = ActiveSheet.UsedRange.Rows.Count     ' scans rows from the end upwards for proper indexing     For lRow = lRows To 2 Step -1         If IsError(Cells(lRow, 4).Value) Then _             If Cells(lRow, 4).Value = CVErr(xlErrNA) Then _                 Rows(lRow).Delete Shift:=xlUp     Next lRow End Sub     However, this is causing Excel to hang. Any ideas why?   Thanks, Oliver Fri, 14 Dec 2018 13:22:00 GMT https://community.blueprism.com/t5/Product-Forum/Excel-Macro-Question/m-p/88980#M39444 OliverMohajeri 2018-12-14T13:22:00Z https://community.blueprism.com/t5/Product-Forum/Excel-Macro-Question/m-p/88981#M39445 Don't forget to set Application.ScreenUpdating to true at the end of the macro. I've found it best to include an error handler to re-enable it, in case the macro fails for some reason. Something like this: Sub Macro()     On Error Goto MacroError     Application.ScreenUpdating = False     ' Do macro stuff....   MacroError:     Application.ScreenUpdating = True End Sub   If it still appears to hang, try stepping through the macro with the Excel debugger to see where the hold up is. Fri, 14 Dec 2018 18:56:00 GMT https://community.blueprism.com/t5/Product-Forum/Excel-Macro-Question/m-p/88981#M39445 NicholasZejdlik 2018-12-14T18:56:00Z