scottrperry
New Member
- Joined
- Nov 19, 2011
- Messages
- 9
In Columns A and B I have created formulas that yield values I will use to hide Rows, such as "hide" and "autohide".
(I have a macro that hides all the rows where "hide" appears in Column B, works fine.)
I need a VBA to hide all Rows wherever Column A changes to "autohide", and unhide them when Column A changes to something other than "autohide".
I'd like to be able to reference named ranges instead of hard coding ranges in the VBA, but that's not a deal breaker.
Any help is appreciated.
(Excel/Office 365)
(I have a macro that hides all the rows where "hide" appears in Column B, works fine.)
I need a VBA to hide all Rows wherever Column A changes to "autohide", and unhide them when Column A changes to something other than "autohide".
I'd like to be able to reference named ranges instead of hard coding ranges in the VBA, but that's not a deal breaker.
Any help is appreciated.
(Excel/Office 365)