Link to home
Create AccountLog in
Avatar of hindersaliva
hindersalivaFlag for United Kingdom of Great Britain and Northern Ireland

asked on

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
ASKER CERTIFIED SOLUTION
Avatar of Norie
Norie

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Beaten by 41 seconds:(
Avatar of hindersaliva

ASKER

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

Thanks!
Please don't forget to give Norie the credit when you close this question.
BTW they both work, ie. with 'Columns' and without.
Thanks both of you.