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

 

[MARK858]

Do you have headers on row 8?
If the answer is yes what happens with the code below?

Sub hideemptyrows2x()
    With Sheets("Indirect Cost Forecast")
        .Range("A8:E" & .Range("E" & Rows.Count).End(xlUp).Row).AutoFilter Field:=5, _
                                    Criteria1:="<>", Operator:=xlAnd, Criteria2:="<>-"
    End With
End Sub

 

[Sonyafm]

Do you have headers on row 8?
If the answer is yes what happens with the code below?

Sub hideemptyrows2x()
    With Sheets("Indirect Cost Forecast")
        .Range("A8:E" & .Range("E" & Rows.Count).End(xlUp).Row).AutoFilter Field:=5, _
                                    Criteria1:="<>", Operator:=xlAnd, Criteria2:="<>-"
    End With
End Sub

Yes, rows below have numbers and I want to show only the numbers no blanks.

 

[MARK858]

Yes, rows below have numbers and I want to show only the numbers no blanks.

That doesn't answer either question I asked.

 

[Sonyafm]

Thanks for your reply,
I tried the new code and the filter goes to the first row.
The sheet has titles on row 8. on Row 1 I have other titles too.

 

[Sonyafm]

The filter continues to go to the incorrect row 1 instead of row 8. This is so bizzare

 

[MARK858]

Post a sample of your data (sanitize any sensitive data). See my signature block below for links to addins to do this or upload a copy of your workbook to a free file hosting site like www.box.com or www.dropbox.com, mark it for sharing and post the link it provides in the thread.

Please do not try and post an unusable image like a Png, Jpeg etc.

 

[Fluff]

Do you have any merged cells?

 

[Sonyafm]

https://www.dropbox.com/s/dxj7ji8ms8pz9as/1000333%20ASC606%20June%20Indirect%20Forecast%20%287%29%20.xlsm?dl=0


It's stab "Indirect Cost Forecast".

Thank you for looking into this. It's quite frustrating not to be able to advance on my code with this roadblock.

 

[MARK858]

Sorry but when I run the code I posted on your file from a regular macro it is putting the filter on row 8.
@Fluff, any chance you can test at your end?