Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Macro
Hi,
I have an requirement in excel to Expand & collapse rows for a certain range. Below is the code written for the same, Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Not Intersect(Target, [H5]) Is Nothing Then [6:10].Rows.Hidden = True End If If Not Intersect(Target, [E:E]) Is Nothing Then [6:10].Rows.Hidden = False End If End Sub However if an user insert a new row i want to include the additional row dynamically to the existing range. Please help |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro
Name the range and use the range in your code.
Me.Range("MyRows").Rows.Hidden = True -- Jim Cone Portland, Oregon USA http://www.contextures.com/excel-sort-addin.html editorial review of special sort excel add-in (30 ways to sort) "kartk" wrote in message ... Hi, I have an requirement in excel to Expand & collapse rows for a certain range. Below is the code written for the same, Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Not Intersect(Target, [H5]) Is Nothing Then [6:10].Rows.Hidden = True 'End If If Not Intersect(Target, [E:E]) Is Nothing Then [6:10].Rows.Hidden = False End If End Sub However if an user insert a new row i want to include the additional row dynamically to the existing range. Please help -- kartk |
#3
|
|||
|
|||
Quote:
Thanks a lot.... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
how to count/sum by function/macro to get the number of record to do copy/paste in macro | Excel Programming | |||
macro to delete entire rows when column A is blank ...a quick macro | Excel Programming | |||
Start Macro / Stop Macro / Restart Macro | Excel Programming |