About Pricing Community Teams Start Free Trial

hindersaliva

asked on 10/24/2016

Excel VBA - Hiding all Columns in a Named Range

I have a named range called "HideTheseColumns". It is 5 rows by 10 columns (say). I'm looking for an elegant way of coding a 'hide columns' procedure.

This code didn't work.

Range("HideTheseColumns").Columns.EntireColumn.Hidden = False

Open in new window

Thanks

VBAMicrosoft Excel

Last Comment

hindersaliva

8/22/2022 - Mon

ASKER CERTIFIED SOLUTION

Norie

10/24/2016

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

GET A PERSONALIZED SOLUTION

Ask your own question & get feedback from real experts

Find out why thousands trust the EE community with their toughest problems.

SOLUTION

Martin Liss

10/24/2016

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

GET A PERSONALIZED SOLUTION

Ask your own question & get feedback from real experts

Find out why thousands trust the EE community with their toughest problems.

Martin Liss

10/24/2016

Beaten by 41 seconds:(

hindersaliva

10/24/2016

ASKER

Haha! That's what I had BUT ........ I put 'False' and expecting the columns to hide! Doh!

Thanks!

Martin Liss

10/24/2016

Please don't forget to give Norie the credit when you close this question.

Your help has saved me hundreds of hours of internet surfing.

fblack61

hindersaliva

10/24/2016

ASKER

BTW they both work, ie. with 'Columns' and without.

hindersaliva

10/24/2016

ASKER

Thanks both of you.

Certified Expert Program

Credly Partnership

Udemy Partnership