R
RLY
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
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