Only one column has multiple rows - hide these rows but easily accessed by click?

**Samik Sil** · 01-23-2012, 11:30 AM

I have a sample sheet with about 1500 clients on the left and information and information across. However, on one of the columns it shows a list of all the subsidiaries of the client. Its the only column with multiple rows of information pertaining to the client. This column is increasing my list to over 18,000 rows. This information is necessary but I want it hidden so it only appears if someone clicks or something similar. See attachment. I would basically want to "hide" E2-16, making the information appear for example if someone clicks E1.

Please advise! If you have a better way to organize the information that would be great as well!

Sample Sheet.xls

Thanks in advance.

**john55** · 01-25-2012, 03:29 AM

hi Samik and welcome!

increase the first row and add two buttons, one hides yr rows and the other one unhide'em.
hope it helps you.

Sub Button1_Click()
Dim Rng As Range
Set Rng = Range("A:A")
Rng.SpecialCells(xlBlanks).EntireRow.Hidden = True  'hide yr rows
End Sub

Sub Button2_Click()
Dim Rng As Range
Set Rng = Range("A:A")
Rng.SpecialCells(xlBlanks).EntireRow.Hidden = 0  'unhide yr rows
End Sub

Thread: Only one column has multiple rows - hide these rows but easily accessed by click?

Thread Tools

Display

Only one column has multiple rows - hide these rows but easily accessed by click?

Re: Only one column has multiple rows - hide these rows but easily accessed by click?

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions