hide a row

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

I have a worksheet with information in column A and B.

If Column B has no information I want to do nothing, but if there is
something in Column B, I would like to hide the row.

Is this possable in an if statement?
 
As Frank said you would need a macro which could be automatic via a
worksheet change event. But, the question is - Do you ever want to unhide
it? If not, just delete.
 
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

Figuring out a lengthy formula. Probably quite simple... 3
Code to hide rows if cell in another WS is ="No" 11
Excel Help to copy information from one row at a time to another sheet 1
MATCH OR VLOOKUP 3
moving rows to another sheet 3
Print macro that hides rows before printing 1
Need to count no. of rows where cell in column A = "value1" AND cellin column B (same row) = "value2 2
Hide Row Numbers/Column Letter in VBA 1

Back
Top