It is not entirely clear from your question whether you want the
ActiveCell's row and column included in the new selection or not. If you
want them included...

ActiveCell.Resize(11, 7).Select

Note the 11 and 7 are your 10 and 6 plus one each. If you don't want them
included...

ActiveCell.Offset(1, 1).Resize(10, 6).Select

In any event... the Offset and Resize properties are the one's you will want
to play with.

--
Rick (MVP - Excel)


"J.W. Aldridge" wrote in message
...
From active cell, select the next 10 rows down, 6 columns over.