Sample Sentences & Example Usage. 1  Jewish Folk Saying: One should not stand at the foot of a sick person's bed, because that place is reserved for the guardian angel. 2  Jean Paul Friedrich Richter: The guardian angels of life sometimes fly so high as to be beyond our sight, but they are always looking down upon us.
Hide unused cells, rows, and columns with Kutools for Excel. If you have Kutools for Excel installed, you can simplify the work and hide unused cells, rows, and columns with only one click. Just select the used working area, and click the Kutools > Show / Hide > Set Scroll Area, then it hides all unused cells, rows, and columns immediately.
VBA To Hide/Show Rows & Columns. I am hoping to find someone that can write this piece of VBA code. I have no experience with it myself, other then basically copying & pasting solutions into the VBA editor. In those cells, there is either no value IE  or 1. If the cell has a 1, then I would like that row / column hidden. Here are some screen shots so you can see what I'm doing... (Keep in mind the images doesn't show the full range) I would like this code to execute (show & hide) when the values in those cells change.