Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: bonjourlena
- Order by date
-
Need a macro that would hide the rows of cells that return #N/A values
Thank you! It works on one workbook. But I have about 20 that I want to apply the macro to. Seems like I cannot apply te auto filter to several workbooks at a time. Ideas?- bonjourlena
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Need a macro that would hide the rows of cells that return #N/A values
I have 20 workbooks that all have the same table in the range of cells C63:P133. The table has formulas in every cell and when the value of the formula returns an error, the cells have #N/A value. I need a macro that would analyze the rows (in case of #N/As, the whole row will have them) and...- bonjourlena
- Thread
- Replies: 3
- Forum: VBA Visual Basic for Applications (Microsoft)
