try this
Sub hidecolinrng()
'Range("hiderng").Cells(1, 3).EntireColumn.Hidden = False
Range("hiderng").Range(Cells(1, 3), Cells(1, 4)).EntireColumn.Hidden = True
'FALSE
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"malcomio" wrote in message
...
Is there a way of hiding columns in named ranges in VBA? I've got a load
of
columns that I want to show and hide, but I might want to add other
columns
in the worksheets later, so named ranges would make life easier.

I would have thought it was simple, but I just get an error that I'm
"unable
to set hidden property of range class"