Good Morning/Afternoon/Evening Everyone,
I am working making a material list in workbook, and i want to hide all $0.00 in the sheet, based on Column "F"
Here is what i have, right now.
Sub HideZeroRows()
Dim CheckNum As Long, LastRow As Long
LastRow = Range("F65536").End(xlUp).Row
For CheckNum = LastRow To 2 Step -1
If Cells(CheckNum, 1).Value = 0 Then Cells(CheckNum, 1).EntireRow.Hidden = True
Next CheckNum
End Sub
Running into the issues that it isnt hiding cells that are based off the criteria F column. It is only hiding "0" cells in the sheet and not $0.00 cells.
Any help is greatly appreciated!
Thanks
Bookmarks