Thanks for the response but I am a novice at this and I can't figure out what
sh.columns(21) means. Could you please explain it and how I am to use it?

Thank you

Neal


"Tom Ogilvy" wrote in message
...
for each sh in Worksheets
sh.Columns(21).Hidden = False
Next

or

for each sh in Activewindow.SelectedSheets
sh.Columns(21).Hidden = False
Next


--
Regards,
Tom Ogilvy

"Neal" wrote in message
...
I have a workbook with seven worksheets. I have recorded several macros
that
have selected all the worksheets and then cleared the contents in a range.
I
have used this same method to hide a column in all the worksheets
successfully
but when I try to unhide a column, it only works on one of the worksheets.
What
code can I use to to unhide the selected column on all seven worksheets.
Thanks
Neal