Run macro on columns with a "defined name"
 

Hello,
I think this is een easy question, but I can't find the answer.

In Excel I had defined names on columns (insert - define name).
For example: Name = test Refers to = $B:$C.
Now I want with a macro that hide the column with the defined name
"test".

regards,
Johan

Run macro on columns with a "defined name"
 

Range("Test").EntireColumn.Hidden = True

--
regards,
Tom Ogilvy


"johan" wrote:

Hello,
I think this is een easy question, but I can't find the answer.

In Excel I had defined names on columns (insert - define name).
For example: Name = test Refers to = $B:$C.
Now I want with a macro that hide the column with the defined name
"test".

regards,
Johan