Hi Paul

with macros like these, the best place to start is with the macro recorder
(tools / macro / record new macro) - and record the actual steps that you
want the macro to perform) and then have a look at the code and tweak it
(tools / macro / macros - edit)

Cheers
JulieD

"PaulM" wrote in message
...
I want to create a command button in a worksheet that will hide/unhide each
alternate column from J - AG as well as row 4. Being new to VBA I've no
idea
how this would look - or if it's even possible. Any ideas?