autofilter

Hello, Im trying to autofilter a Excel Pivot Table. If I run the code in a normal sheet , it works, but when I run the same code to filter a dynamic range I get an error. I need to filter the column "D" with two criterias This is the code I'm using: Dim sw, dw As Object Dim ss, ds As...

Hi, The Snippet runs perfectly in excel but when pasted into the Code section of the Code box properties; it throws an error. It requires the 'method argument' to be in parentheses. This is unusual as the VB syntax doesn't follow this requirement. ======...

Hi, I am trying to apply autofilter to one of my date column inorder filter data between two dates. I am using code stage to achieve this, below is the code I am using GetWorkbook(handle,Nothing).Worksheets(sheetName).Activate...