Hide Rows & Columns with Simple Function

**babyjohnson** · 09-02-2016, 10:08 AM

Hi All,

I'm trying to hide & un-hide rows & columns where the values are ZERO in a specified rows & columns in a large report. I have attached a sample file & highlighted the rows which needs to be hidden.

Please let me know if there is a formulae or how to build a macro (step by step).

Thanks in advance
John

**alansidman** · 09-02-2016, 10:49 AM

Here are two macros

Please Login or Register  to view this content.

Please Login or Register  to view this content.

**MarvinP** · 09-02-2016, 10:57 AM

Hi John,

See if this VBA code can make sense to you.

Please Login or Register  to view this content.

**babyjohnson** · 10-08-2016, 09:03 AM

Thank you Marvin

**babyjohnson** · 10-08-2016, 09:04 AM

Thank you Alan

**alansidman** · 10-08-2016, 11:15 AM

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

Hide Rows & Columns with Simple Function

LinkBack

Thread Tools

Rate This Thread

Display

Hide Rows & Columns with Simple Function

Re: Hide Rows & Columns with Simple Function

Re: Hide Rows & Columns with Simple Function

Re: Hide Rows & Columns with Simple Function

Re: Hide Rows & Columns with Simple Function

Re: Hide Rows & Columns with Simple Function

Thread Information

Users Browsing this Thread

Similar Threads

Hide Rows/Hide Columns Based on Value in Cell

VBA code to hide filtered columns (simple table 5 rows / 6 columns wide)

Ugh! I need what I thought would be a very simple Macro to hide rows

Simple Script to hide rows - runs slow

simple macro to hide or unhide rows based on a cell value

[SOLVED] Simple macro to hide rows running very slowly

hiding columns or rows not using the hide function

Bookmarks

Bookmarks

Posting Permissions