VBA Help: Hide all Columns that have a "N/A" in the total line

[JazzyJellyB]

I have looked over this forum for days so I have to break down and ask.

I have several tabs (25) and 30+ columns with identical formatting that look like this:

	PROD1	PROD2	PROD3	PROD4
XXXX	1111	2222	0	3333
YYYY	11	22	0	44
ZZZZ	1	1	01
ABAB	2	2	N/A	2

<tbody>
</tbody>

I am trying to find a VBA code that will hide any column in each spreadsheet where "N/A" is found.

Thanks in advance.

 

[Special-K99]

Your solution should really be to prevent the NA's from occurring in the first place, perhaps using

=IFERROR(formula,"")

 

[JazzyJellyB]

Sorry: To add, the row ranges from K through BW

 

[JazzyJellyB]

Your solution should really be to prevent the NA's from occurring in the first place, perhaps using

=IFERROR(formula,"")

However, I would still need to hide the column.

 

[JazzyJellyB]

I found this from an earlier post! I am sorry I can't remember the orginal person that came up with it. I just edited it.

Sub HideColumns()
Application.ScreenUpdating = False
For i = 26 To 1 Step -1
If Cells(2, i).Value <> "" Then
If Cells(2, i).Value = 0 Then Columns(i).Hidden = True
End If
Next i
Application.ScreenUpdating = True
End Sub