Hide row if cell is empty

**JamesT1** · 07-28-2009, 05:43 PM

Hi Guys

I'm looking for a way to hide a row if the cell is column A is empty. On the attached sheet I'm looking to hide the empty rows below the last vehicle registration.

Thanks In advance

**Leith Ross** · 07-28-2009, 08:35 PM

Hello JamesT1,

I added a Toggle Button to "Sheet1" to allow you to hide and view the rows. You can remove the button if you like and just the macros in your code. Here are the macros that have been added to the attached workbook.

Toggle Button Macro

Please Login or Register  to view this content.

Hide Rows and Show Rows Macros

Please Login or Register  to view this content.

**JamesT1** · 07-30-2009, 12:49 PM

hi Leith Ross

Just what the doctor ordered, your help is very much appreciated

JT

**dhnorris89** · 05-25-2012, 10:24 AM

Selections Summary 1 Sent.xlsm

Hi Leith Ross,

I need a similar code written and was wondering if you could help me out. I already have a macro written that Adds a new entry and sheet. All I need to complete it is to hide the rows and also to change the sheet name to whatever is in the location cell. I would greatly appreciate your help.

Thanks,

DN

**arlu1201** · 05-25-2012, 10:26 AM

Dhnorris89,

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.