Hide Not e

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If any cell in the range A4:D10 has a value, I want to hide rows A1:D9. How
do I do that? I find examples for hiding rows if a cell(s) has a certain
value, but not if it just not empty.
Thanks,
Howard
 
That should say ...I want to hide rows A1:D3. I accidentally hit the Post
button before I wanted to.
 
Frank,
I want to hide rows, if any of those cells are NOT empty.
Thanks,
Howard
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hide / Unhide each row from StartRow to LastRow for multiple conditions 6
Shorter way to do this 8
Paste in column B using Last row of either column B, C or D. 10
Hiding rows 1
Entering value into cell via VB code if cell is empty 6
hiding blank rows 3
Hiding and unhiding rows 8
using a value in a cell to hide rows 8

Back
Top