VBA Hiding columns if value equal to zero

**Andrea Maccaferri** · 03-22-2022, 04:15 AM

Hello,
I'd like to hide the columns in the file if the columns have no value (zero in every cell of the columns).
I tried with VBA but it doesn't work.

anyone can help me?

**jindon** · 03-22-2022, 04:28 AM

Something like

Please Login or Register  to view this content.

**Andrea Maccaferri** · 03-22-2022, 05:00 AM

your macro works well !!
thanks a lot.
if I want to hide also empty columns?

**jindon** · 03-22-2022, 05:05 AM

Change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Or maybe

Please Login or Register  to view this content.

**Andrea Maccaferri** · 03-22-2022, 05:52 AM

THANKS !!!
I really appreciate your skills

VBA Hiding columns if value equal to zero

LinkBack

Thread Tools

Rate This Thread

Display

VBA Hiding columns if value equal to zero

Re: VBA Hiding columns if value equal to zero

Re: VBA Hiding columns if value equal to zero

Re: VBA Hiding columns if value equal to zero

Re: VBA Hiding columns if value equal to zero

Thread Information

Users Browsing this Thread

Similar Threads

Hiding columns in excel without hiding form button

Trying to convert a horizontal filter from hiding columns that contain to hiding all other

Un-Hiding and Hiding Columns based on Drop-Down Values in a Column.

Un-Hiding and Hiding Columns based on Drop-Down Values in a Column.

hiding all rows except the last with an equal number

[SOLVED] PIVOT TABLE - hiding records with CALCULATED item values equal to

[SOLVED] Hiding column/row labels --without hiding entire columns/rows

Bookmarks

Bookmarks

Posting Permissions