Hi all: I can't seem to recall the VBA syntax to show all data in a worksheet, which has AUTOFILTER set.

In my VBA code, I have a total of 4 worksheets that is used. How would I be able to show all data in worksheet 2 per se? Please note, I do not want to remove the AutoFilter - just need to remove any filters applied to whatever columns.

I read I can use:

ActiveSheet.ShowAllData

But in this case, what is the syntax to replace "ActiveSheet" with the appropriate worksheet (Ie. Sheet2)

Thanks for helping a VBA newbie