VBA to Auto Hide Rows with N/A as Value

[Bkisley]

Hey guys! I have a macro created that is near perfect for what I need. The only downfall is that it leaves the 50 rows the macro deals with unhidden. I need to add to my macro to hide all rows with rows 56 and 105 that have a value of N/A in column A.

Example - cells A56:A66 all have a percent in the cell. Cells A67:A105 have N/A in the cell. When I click my macro button, I need to automatically hide rows A67:105. If I then add to my data and now A56:A75 now have a percent in the cell, I would need my macro (when clicked for the second time) to leave rows A56:A75 unhidden and hide A76:A105

What do I need to do??


Thanks!

 

[Bkisley]

Yeah I don't have an issue with doing that. I will then just add in a conditional formatting where if a cell is false use white text so I don't see a bunch of cells that show False.
Thanks again!

 

[Fluff]

There's no need to use cf as those cells will be hidden anyway.

 

[Rick Rothstein]

If you are happy to change your formula so that, rather returning "N/A" it returns FALSE (no quotes) you could use

Range("A56:A105").SpecialCells(xlFormulas, xlLogical).EntireRow.Hidden = True

Since the values returned are either numbers or "N/A", he should be able to use this formula without changing the "N/A" to "FALSE"...

Range("A56:A105").SpecialCells(xlFormulas, xlTextValues).EntireRow.Hidden = True