ExceLoki
Well-known Member
- Joined
- Dec 13, 2021
- Messages
- 541
- Office Version
- 365
- Platform
- Windows
i have a workbook that contains many sheets that pull values from an input sheet. some of the formulas on many sheets say "HIDE ROW" if the input does not work for those sections.
i am trying to come up with vba to hide entire rows if anywhere in the row has the shown value "HIDE ROW". this goes across several sheets, rows, and columns.
any help is apperciated!
i am trying to come up with vba to hide entire rows if anywhere in the row has the shown value "HIDE ROW". this goes across several sheets, rows, and columns.
any help is apperciated!