I've developed a VB application that does some OLE Automation using Excel.

I want to check that there is no autofilter currently active and that all
rows are shown (but still keep the AutoFilter enabled).

The code to this is within a VBA macro is

Activesheet.ShowAllData

(I believe)

However when I try to do this within VB e.g

Dim X as New Excel.Application
.......
X.ActiveSheet.ShowAllData

I get object does not support method.

Any ideas what I am doing wrong?