Toggle Hide/Show
 

Hi Alan,

Here you go

Columns("C:G").Hidden = Not Columns("C:G").Hidden

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Alan" wrote in message
...
Greetings,
I would like button that the first time its clicked, will hide columns C:G
and when clicked the next time will show the same columns. I can write the
code to separately hide or show but I dont know how to combine them to
toggle when the button is clicked.
All help is greatly appreciated!
Alan