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