I'm home now and yes, i tried it and it works. Didn't know it would be something that easy.

Rows(k & ":" & Rows.Count).Hidden = True
Also, on the Type Mismatch error, i think it was because i pasted the code before i initialised 'k'.
Anyways it works now, so thanks

EDIT: wizard7070, i think that also works since the principle is the same, the solution right now is shorter thou, but thanks for the help anyway !