Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
hide/unhide rows depending on the top input value
Hi
I need help to edit macro below that specific range of rows could hiding/unhiding depending on the top input value. In this instance the results are changing dynamically when the input values are changed: "Private Sub Worksheet_Change(ByVal Target As Range) Dim rngIn As Range Dim rngOut As Range Dim iMax As Long Set rngIn = Me.Range("A1:C1") Set rngOut = Me.Range("A3:A40") iMax = Application.Max(rngIn) If Not Intersect(rngIn, Target) Is Nothing Then On Error GoTo XIT Application.EnableEvents = False Range(rngOut, rngOut.End(xlDown)).ClearContents Set rngOut = rngOut.Resize(iMax + 1) rngOut(1) = 0 rngOut.DataSeries Rowcol:=xlColumns, Type:=xlLinear, _ Step:=1, Trend:=False End If XIT: Application.EnableEvents = True End Sub" Thanx in advance! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
hide/unhide rows depending on the top input value
Which rows get hidden? You can toggle like so
Rows("12:20").Hidden = Not Rows("12:20").Hidden -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "TiDz" wrote in message ... Hi I need help to edit macro below that specific range of rows could hiding/unhiding depending on the top input value. In this instance the results are changing dynamically when the input values are changed: "Private Sub Worksheet_Change(ByVal Target As Range) Dim rngIn As Range Dim rngOut As Range Dim iMax As Long Set rngIn = Me.Range("A1:C1") Set rngOut = Me.Range("A3:A40") iMax = Application.Max(rngIn) If Not Intersect(rngIn, Target) Is Nothing Then On Error GoTo XIT Application.EnableEvents = False Range(rngOut, rngOut.End(xlDown)).ClearContents Set rngOut = rngOut.Resize(iMax + 1) rngOut(1) = 0 rngOut.DataSeries Rowcol:=xlColumns, Type:=xlLinear, _ Step:=1, Trend:=False End If XIT: Application.EnableEvents = True End Sub" Thanx in advance! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
hide/unhide rows depending on the top input value
Hi Bob
Actually I need that depanding on the top value (from 1 to 40) in the specific range stay on adequate quantity of the 40 rows in the specific range in the sheet. "Bob Phillips" rašė: Which rows get hidden? You can toggle like so Rows("12:20").Hidden = Not Rows("12:20").Hidden -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "TiDz" wrote in message ... Hi I need help to edit macro below that specific range of rows could hiding/unhiding depending on the top input value. In this instance the results are changing dynamically when the input values are changed: "Private Sub Worksheet_Change(ByVal Target As Range) Dim rngIn As Range Dim rngOut As Range Dim iMax As Long Set rngIn = Me.Range("A1:C1") Set rngOut = Me.Range("A3:A40") iMax = Application.Max(rngIn) If Not Intersect(rngIn, Target) Is Nothing Then On Error GoTo XIT Application.EnableEvents = False Range(rngOut, rngOut.End(xlDown)).ClearContents Set rngOut = rngOut.Resize(iMax + 1) rngOut(1) = 0 rngOut.DataSeries Rowcol:=xlColumns, Type:=xlLinear, _ Step:=1, Trend:=False End If XIT: Application.EnableEvents = True End Sub" Thanx in advance! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Enabling option „Format rows“ to hide/unhide rows using VBA-code? | Excel Discussion (Misc queries) | |||
hide and unhide rows | Excel Programming | |||
Hide Unhide Rows | Excel Discussion (Misc queries) | |||
Hide/Unhide Rows | Excel Programming | |||
Hide/Unhide rows | Excel Programming |