How to select a range of rows from the current cell?

[culcuhain]

I have a spreadsheet where the final active cell changes. (using Selection.end(xldown).select to get to that cell (number of rows in a pivot table changes).

I need to know how to select the row where the active cell is and 4 more rows and then hide those 4 rows.

I hope this makes sense. Thanks!

 

[Andrew Poulsom]

Four more rows below?

Activecell.Resize(5).EntireRow.Hidden = True