Re-activate a sheet twice?

[Russk68]

Hi All
I am working with 2 sheets.
Sheet 1 is manual calculation and on deactivate, it calculates sheet 2.
Sheet 2 has code to autofilter the sheet.
The problem is that when I open sheet 2, the filter macro runs before the calculation finishes that is triggered when I leave sheet 1.
I have to change sheets twice for sheet 2 to filter the calculated information.
Is there a way to re-activate the sheet or run the code on the sheet a few times?

Thank you!

Russ

 

[Yongle]

... or introduce a delay

I already posted this on your other thread
https://www.mrexcel.com/forum/excel-questions/1092490-delay-vba-before-running.html

Private Sub Worksheet_Activate()
    Dim a As Long   
    For a = 1 To 500
        Me.Activate
    Next a 
    Range("A:A").AutoFilter 1, "<>0"
End Sub