I have a Worksheet and the first 49 rows have data on it,
now i want to hide rows 50 to the end of the document, but cant seem to figure this out...
Right now i'm trying this: (h = 7)
Dim n As Integer n = Cells.SpecialCells(xlCellTypeLastCell).Row k = 7 * h + 1 Rows("k:n").Hidden = True