Problem using filter property
Hi
I have the following code in my VBA
Set w = Worksheets("A")
w.Cells.AutoFilter field:=11, Criteria1:="S"
It works fine, but it displays the results from row 2 of the sheet.
I have my heading from cell A1 to M4 , so when I use this code the heading
from row a2 : m5 are hidden under the output os the result.
I want the ouput to start from Cell a5.
Please help
|