| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Message "user defined type not defined" | Excel Discussion (Misc queries) | |||
| "User-defined type not defined" error when trying to send e-mail | Excel Programming | |||
| 1004 "Application-defined or object-defined error" | Excel Programming | |||
| "Application-defined or object-defined error" while printing excel report | Excel Programming | |||
Hybrid Mode
