Need help with 2 different macros - Rows and Columns

[Dragct]

I have a workbook with several macros and I am stumped on two specific macros and would like to ask for some help.

First One:

I want to Hide All of the Rows (22:236) that do NOT have any data in columns B thru M. I have the following set up and it works for column B (B22:B236), but if I set a Range (B22:M236), it hides all of my rows. FYI, I have multiple header rows...I tried to attach some screen shots in a word doc, but it would not allow me to...just kept spinning. Anyways, Here is what I have:

Please Login or Register  to view this content.

Second One:

In the SAME workbook, I have several spreadsheets in which I want to hide the columns if the Data in a particular cell = 0. I have it working for one of the spreadsheets, just not sure how to make it happen on all at the same time. Here is what I have.

Please Login or Register  to view this content.

The spreadsheets that I would like to hide on one button click are:

1. Operating Budget - Based on G3:M3 being 0
2. Travel Budget Details - Based on H8:N8 being 0
3. Total Operating Budget - Based on D4:J4 being 0

[walruseggman]

Please put your code in code tags, so that it looks like my code below. Edit the post, highlight the code, then select the # button in the text editor.

Please Login or Register  to view this content.

[Dragct]

Thank you for the quick response. I put my code in the code tags...did not know I should do that.

The first one on Hiding Rows works perfectly. Thank you.

On the second one, when I ran it, it hid All of the columns in the Operating Budget sheet and no columns in the other two sheets. Any thoughts?

Thanks again! Kim

[walruseggman]

Hmm, might have to post the workbook.

Double check that the worksheet names are correct (like there aren't any hidden spaces or anything in your tab names).

[Dragct]

How do I post the workbook?

[walruseggman]

Click the Go Advanced button in the lower right of hte quick reply, you'll see an attachment button in the editor.

[Dragct]

OP16 Budget Template 2015-02-12.xlsmMacro Screen Shots.docx

Gotcha. Thanks...I am new to this forum. Hope this worked.

[walruseggman]

Oops. I forgot to reference the ranges on the specific sheets. Add "ws." to all the ranges, as shown below in the example:

Please Login or Register  to view this content.

[Dragct]

THANK YOU, THANK YOU, THANK YOU!!! I am so excited. I really appreciate your patience and your help with this. Have a wonderful weekend.

[walruseggman]

Great! Please mark this thread as SOLVED (instructions below), and any reputation points (the * in the lower left of my posts) is appreciated.

• -Go to the top of the first post
• -Select Thread Tools
• -Select Mark thread as Solved