ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Temporarily Unhiding (https://www.excelbanter.com/excel-discussion-misc-queries/160162-temporarily-unhiding.html)

[email protected]

Temporarily Unhiding
 
I hid certain rows which may have test data in them that may need to
be removed, but I would then need to hide them again. I would prefer
to somehow "temporarily unhide" then bring back the "Old hiding".

- = -
Vasos Panagiotopoulos, Columbia'81+, Reagan, Mozart, Pindus, BioStrategist
http://ourworld.compuserve.com/homepages/vjp2/vasos.htm
---{Nothing herein constitutes advice. Everything fully disclaimed.}---
[Homeland Security means private firearms not lazy obstructive guards]
[Urb sprawl confounds terror] [Remorse begets zeal] [Windows is for Bimbos]

Mike H

Temporarily Unhiding
 
Hi,

Use the code I gave you in your other post to hide unhide a row based on a
cell value.

Mike

" wrote:

I hid certain rows which may have test data in them that may need to
be removed, but I would then need to hide them again. I would prefer
to somehow "temporarily unhide" then bring back the "Old hiding".

- = -
Vasos Panagiotopoulos, Columbia'81+, Reagan, Mozart, Pindus, BioStrategist
http://ourworld.compuserve.com/homepages/vjp2/vasos.htm
---{Nothing herein constitutes advice. Everything fully disclaimed.}---
[Homeland Security means private firearms not lazy obstructive guards]
[Urb sprawl confounds terror] [Remorse begets zeal] [Windows is for Bimbos]



All times are GMT +1. The time now is 03:06 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com