On Mon, 05 Jan 2009 20:01:41 GMT, Lars-Åke Aspelin
wrote:

On Mon, 05 Jan 2009 19:54:16 GMT, Lars-Åke Aspelin
wrote:

On Mon, 5 Jan 2009 11:39:02 -0800, cvgairport
wrote:

Hi there,

Can a VB macro be written to hide 3 rows at the cell position - no matter
where the current cell position is. I can write a macro to select specific
row numbers, but I want one that will take the 3 rows from the current cell.

Thanks!

Amy



Try this

Selection.Resize(3, 1).EntireRow.Hidden = True

This will hide the (top) row of the current selection together with
the two following rows.

Hope this helps / Lars-Åke

The above formula can be shortened a bit

Selection.Resize(3, 1).Rows.Hidden = True

Lars-Åke

Even shorter :-)

Selection.Resize(3).Rows.Hidden = True

Lars-Åke