Hide / unhide column in VBA

  • Thread starter Thread starter Guest
  • Start date Start date
Hi Patrick

Sheets("sheet1").Columns("A:C").EntireColumn.Hidden = True

False to get them back
 
With Worksheets("Sheet1").Columns("A")
.Hidden = Not .Hidden
End With

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hide / Unhide each row from StartRow to LastRow for multiple conditions 6
Macro to Hide/Unhide various columns 5
How to Disable/Enable hide entire row ability 17
Hide unhide non-contiguous columns 6
Hide rows and prevent unhiding 2
Hide / Unhide Columns in Password Protected w/s 2
hide & unhide toggle button 3
HIDE-UNHIDE VBA MACRO 1

Back
Top