Create Macro that will 'hide" rows that have no variables in column C

**BAWILS** · 04-04-2013, 02:43 PM

Hopefully this is simple!? I would like to Create Macro that will 'hide" rows that have no variables in column C. Worksheet is attached....

KegForumHelp.xlsx

**davesexcel** · 04-04-2013, 07:36 PM

Possibly,

Please Login or Register  to view this content.

**BAWILS** · 04-04-2013, 07:50 PM

the end range needs to be indefinate because i am constantly adding rows. I don't think C104 will work.

**Trebor76** · 04-04-2013, 09:25 PM

the end range needs to be indefinate because i am constantly adding rows. I don't think C104 will work.

Try this then:

Please Login or Register  to view this content.

Robert

**jindon** · 04-04-2013, 09:47 PM

Autofilter

Please Login or Register  to view this content.

**BAWILS** · 04-04-2013, 10:16 PM

jindon: That worked...except. I need rows 1 thru 5 to NOT be affected by it...AND I need a macro (or some way) to undo it. Can you help with this? Your Code is the only one I have found to work and I have this posted on several forums...THANKS!!!

**jindon** · 04-04-2013, 10:28 PM

Do you mean

Please Login or Register  to view this content.

?

**Trebor76** · 04-05-2013, 06:05 AM

I have this posted on several forums

As per Rule 8 of this forum rules found here:

Don't cross-post without a link. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post. Expect cross-posts without a link to be closed.