Checkbox to hide and unhide rows Please.

S

Steved

Hello from Steved

Below will hide and unhide columns

What is required please to hide and unhide rows

Private Sub CheckBox1_Click()
Dim r As Range
Set r = Range
("D1:E1,G1:H1,J1:K1,M1:N1,P1:Q1,S1:T1,V1:W1,Y1:Z1,AB1:AC1")
r.EntireColumn.Hidden = Not r.EntireColumn.Hidden
End Sub

Thankyou.
 

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

Is there away to shorten 2
A check box to open and close Columns 2
Code for button to hide/unhide rows 5
Formula too long 2
Hide and Unhide Rows button 6
How to Hide and Unhide Rows 2
Enabling option „Format rows“ to hide/unhide rows using VBA-code? 0
How to hide and unhide Rows & Columns 3

Top