Dim numberrows As integer
numberrows = Me.textbox.Value + 5
Rows("numberrows.value").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.EntireRow.Hidden = True
Hi guys,
I'm trying to get this code to work. However, I keep getting an error for this part:
Rows("numberrows.value").Select
I'm guessing I did not properly define the valuw between the brackets, but I do not know how to fix this, anny suggestions?
Thanks!
Schzuki
P.S.: 'numberrows' is defined as a user entered numerical value + 5
Bookmarks