Code lines color and hide columns

**Tyso** · 10-10-2013, 02:03 AM

Hi Everyone

I use these 2 lines in my code:

Please Login or Register  to view this content.

The line Tab color works perfect - it color all the tabs red.
The line EntireColumn hidden doesn't hide the specified columns

Any assistance will be much appreciated.

**DiCaver** · 10-10-2013, 02:41 AM

Hi Tyso,

at the moment I'm not able to test, but I think that second line works only per one sheet ... I don't know what do you have in "MyArr(Itm)" - one or more sheets ... assuming from first line, that you have multiple sheets ... try to apply second line to sheet by sheet, not to array of sheets.

Cheers, Marko

**Tyso** · 10-10-2013, 03:10 AM

Hi Marko

Thank you for your quick reply!
In "MyArr(Itm)" i have 84 sheets!

**rkey** · 10-10-2013, 03:25 AM

Try this then:

Please Login or Register  to view this content.

**Tyso** · 10-10-2013, 03:49 AM

Hi Marko

"apply second line to sheet by sheet, not to array of sheets"

Thank you - it works

Code lines color and hide columns

LinkBack

Thread Tools

Rate This Thread

Display

Code lines color and hide columns

Re: Code lines color and hide columns

Re: Code lines color and hide columns

Re: Code lines color and hide columns

Re: Code lines color and hide columns

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] What code can I use to hide columns with the same header?

[SOLVED] varying number of columns, multiple similar lines of code (needs condensing)

Help to Add a few lines to macro code to hide the cell formula and to autofill

VBA code to hide empty columns.

VB Code to Hide Columns

Bookmarks

Bookmarks

Posting Permissions