Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to Unhide Rows
Need help with an excel 2003 macro to simply unhide a certain number of rows
in a spreadsheet (# of rows to be unhidden is based on user input). Here's what I have & it's not working... With Sheets("Inputs").Select X = Range("U2") Y = Range("X2") Rows("X:Y", 0).Select Range("Y").Activate Selection.EntireRow.Hidden = False End With U2 is a fixed entry, the row # in X2 is calculated based on a user input (# of additional rows required). Thanks, Robert |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to Unhide Rows
With Sheets("Inputs").Select
x = Range("U2") Y = Range("X2") Rows(x & ":" & Y).EntireRow.Hidden = False Range("A" & Y).Activate End With If this post helps click Yes --------------- Jacob Skaria "RLY" wrote: Need help with an excel 2003 macro to simply unhide a certain number of rows in a spreadsheet (# of rows to be unhidden is based on user input). Here's what I have & it's not working... With Sheets("Inputs").Select X = Range("U2") Y = Range("X2") Rows("X:Y", 0).Select Range("Y").Activate Selection.EntireRow.Hidden = False End With U2 is a fixed entry, the row # in X2 is calculated based on a user input (# of additional rows required). Thanks, Robert |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to Unhide Rows
With Sheets("Inputs")
X = .Range("U2").value Y = .Range("X2").value .Rows(x & ":" & y).hidden = False End With RLY wrote: Need help with an excel 2003 macro to simply unhide a certain number of rows in a spreadsheet (# of rows to be unhidden is based on user input). Here's what I have & it's not working... With Sheets("Inputs").Select X = Range("U2") Y = Range("X2") Rows("X:Y", 0).Select Range("Y").Activate Selection.EntireRow.Hidden = False End With U2 is a fixed entry, the row # in X2 is calculated based on a user input (# of additional rows required). Thanks, Robert -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to Unhide Rows
That sure works - Thank You!
"Jacob Skaria" wrote: With Sheets("Inputs").Select x = Range("U2") Y = Range("X2") Rows(x & ":" & Y).EntireRow.Hidden = False Range("A" & Y).Activate End With If this post helps click Yes --------------- Jacob Skaria "RLY" wrote: Need help with an excel 2003 macro to simply unhide a certain number of rows in a spreadsheet (# of rows to be unhidden is based on user input). Here's what I have & it's not working... With Sheets("Inputs").Select X = Range("U2") Y = Range("X2") Rows("X:Y", 0).Select Range("Y").Activate Selection.EntireRow.Hidden = False End With U2 is a fixed entry, the row # in X2 is calculated based on a user input (# of additional rows required). Thanks, Robert |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to Unhide Rows
One more issue:
The max # of additional rows that can be unhidden is 16. How can I apply this limit within the macro (if the user enters "17" an error will occur)...? Thank You. "RLY" wrote: That sure works - Thank You! "Jacob Skaria" wrote: With Sheets("Inputs").Select x = Range("U2") Y = Range("X2") Rows(x & ":" & Y).EntireRow.Hidden = False Range("A" & Y).Activate End With If this post helps click Yes --------------- Jacob Skaria "RLY" wrote: Need help with an excel 2003 macro to simply unhide a certain number of rows in a spreadsheet (# of rows to be unhidden is based on user input). Here's what I have & it's not working... With Sheets("Inputs").Select X = Range("U2") Y = Range("X2") Rows("X:Y", 0).Select Range("Y").Activate Selection.EntireRow.Hidden = False End With U2 is a fixed entry, the row # in X2 is calculated based on a user input (# of additional rows required). Thanks, Robert |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Code to Unhide Rows using Macro | Excel Worksheet Functions | |||
Can you hide and unhide rows with a macro based on content of colu | Excel Programming | |||
unhide row does not unhide the hidden rows | Excel Worksheet Functions | |||
Macro that will unhide then hide rows | Excel Discussion (Misc queries) | |||
How do I hide or unhide zero value columns/rows USING A MACRO? | Excel Discussion (Misc queries) |