AutoFilter isn't working it goes to another row

[Sonyafm]

Thank you in advance!

I have two issues with Autofilter
1. Autofilter is going to the first row instead of row 8
2. Is not filtering out blanks and/ or cells with formula that results in a "-" o dash
Code:

Sub hideemptyrows2()

Worksheets("Indirect Cost Forecast").Activate


Sheets("Indirect Cost Forecast").Activate
Rows("8:8").Select
Selection.AutoFilter Field:=5, Criteria1:="<>"

End Sub

 

[Sonyafm]

@ MARK58 Yes it works in a brand new excel spreadsheet. @Fluff no merged cells.

Should I create a brand new workbook?

Thank you
Sonya

 

[Sonyafm]

@MARK858 It worked when I put it in a brand new worksheet and @Fluff I removed all merged cells. Do you think it's worth it to begin with a brand new worksheet?

 

[Fluff]

The problem is within the Apply_click event.
You are filtering row 1 but not removing the filter before calling hideemptyrows2.
At the end of the Apply_click code you have

Cells.AutoFilter

Replace that with

 Worksheets("Indirect Cost Forecast").AutoFilterMode = False

and you should be ok.

 

[Sonyafm]

@Fluff, Now the filter is on row 8!!! yay

However, is not filtering out the blanks o the cells that have a "-" ???

 

[Fluff]

You need to use

Criteria2:="<>0"

 

[MARK858]

@Fluff, Now the filter is on row 8!!! yay

However, is not filtering out the blanks o the cells that have a "-" ???

Where are the cells with a "-" in column E? and you only have blanks on E30 and E61.

If you mean the cells with 0 then see Fluffs response.

 

[Sonyafm]

Hallelujah!! Thank you so much You rock!!!
What a great forum!

 

[Fluff]

Glad we could help & thanks for the feedback