VBA command to show all data - Autofilters

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

Hi, you can reference a worksheet using

Sheets("Sheet2")

Where sheet2 is the tab name
or

Sheets(2)

Where 2 is the index, or position of the sheet in the worksheet
or

Sheet2

Where Sheet2 is the name of the vba object of the worksheet (in the project tree)

So using the first method:

Macro_show_data()
Sheets("Sheet2").ShowAllData
End Sub

Ragukluy: Ah geez....it's that easy. THANKS SO MUCH! Works like a charm. Feel a bit embarrassed..something so simple can cost so much time.

Thanks again,
Melissa