I am using this code:
to find the final row.![]()
FinalRow = Cells(65536,1).End(xlUp).Row
Now I want to hide rows 7 through the final row.
I tried this:
Those commands work if I specify any number instead of FinalRow, but I don't know how many lines there will be. Any help?![]()
Rows("7:FinalRow").Select Selection.EntireRow.Hidden = True
Thanks for the note. Someone said that before, but I didn't understand what they meant.
Thanks!
I also triedThat didn't work either.![]()
Rows("7:"FinalRow"").Select
Bookmarks