hide columns if they are empty populated from userform

**KK1234** · 04-07-2014, 06:56 AM

Hi all,
Following code works fine. It will hide column if row 2 is empty ( But only for data in row 2 of the respective columns)
How do I get it it work for the entire columns?

Please Login or Register  to view this content.

Test file is attached
Need some help please
Kind regards

**MarvinP** · 04-07-2014, 07:19 AM

Hi KK,
Try this code instead of yours.

Please Login or Register  to view this content.

**MarvinP** · 04-07-2014, 07:32 AM

If you don't want to count from 6 to 14 and use column letters then this will work also.

Please Login or Register  to view this content.

**KK1234** · 04-07-2014, 08:08 AM

Hi MarvinP,
Great work.
I have understood your code and it works fine.
Really appriciated your help.
Many thanks
Kind regards

**KK1234** · 04-07-2014, 08:10 AM

Hi again,
I have two more questions, however as per forum rule they will have to be in another Thread.
See you soon
Kind regards

hide columns if they are empty populated from userform

LinkBack

Thread Tools

Rate This Thread

Display

hide columns if they are empty populated from userform

Re: hide columns if they are empty populated from userform

Re: hide columns if they are empty populated from userform

Re: hide columns if they are empty populated from userform

Re: hide columns if they are empty populated from userform

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Hide empty columns Toggle

[SOLVED] Hide empty rows of shown columns

VBA code to hide empty columns.

Un hide non empty columns

[SOLVED] Un hide non empty columns

Bookmarks

Bookmarks

Posting Permissions