Screen Updating = True End Sub Activating another worksheet and then again activating the required worksheet worked for me - I had a code where the screen updating failed, I activated another worksheet and then again the one I was working on, it updated the current screen. Screen Updating = False ''''''code''''''' Thisworkbook.worksheets(any otherworksheet in workbook).activate Thisworkbook.worksheets(current worksheet).activate application.
While I'm fine with experimenting with different Add-Ins, if you have a recommendation for one that suits well, it would be awesome.To make sure this is efficient going forward, I want to prevent that from happening. Enable Events = False Dim bk As Workbook Dim result As Long Dim a WB As Workbook Dim a WS As Worksheet Set a WB = Active Workbook Set a WS = Active Workbook. Here is currently what my code looks like: Sub find Row() Application. Without a code sample it is very dificult to understand your problem (please see https://stackoverflow.com/help/how-to-ask and edit your question appropriately. Here are some ideas: - Check if your code calls for code in a different procedure, maybe the Application. (I can "trick" it into changing view to the newly active worksheet by inserting a "Msg Box" - but don't want to do that.) This has been a hard one for me to search out answers (because looking up "Screenupdating" and anything else brings up a myriad of answers regarding "how to stop the screen from updating"). Display Alerts = True End Sub Private Sub ADSform Gen() Application.