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...