From active cell, select the next 10 rows down, 6 columns over.

Range(Cells(activecell.Row,activecell.Column),
Cells(activecell.Row+10,activecell.Column+6)).select

If this post helps click Yes
---------------
Jacob Skaria


"J.W. Aldridge" wrote:

> From active cell, select the next 10 rows down, 6 columns over.
>

Range(Cells(activecell.Row,activecell.Column),
Cells(activecell.Row+10,activecell.Column+6)).select

--
If this post helps click Yes
---------------
Jacob Skaria


"J.W. Aldridge" wrote:

> From active cell, select the next 10 rows down, 6 columns over.
>

Mr. Jacob, that didn't work...

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" <(E-Mail Removed)> wrote in message
news:6cc35d8c-8266-4379-8f96-(E-Mail Removed)...
> From active cell, select the next 10 rows down, 6 columns over.

thanx...

wanted to select the entire range, so the first one worked.

Try this.....it was too long...

Range(Cells(ActiveCell.Row, ActiveCell.Column), _
Cells(ActiveCell.Row + 10, ActiveCell.Column + 6)).Select


If this post helps click Yes
---------------
Jacob Skaria


"J.W. Aldridge" wrote:

> Mr. Jacob, that didn't work...
>

This is much easier to do using the Resize property of the Range object (the
ActiveCell in this case)...

ActiveCell.Resize(11, 7).Select

where the 11 and 7 are one more than the number of rows and columns to add
(the one being so that the 10 and 6 are in addition to the ActiveCell's row
and column).

--
Rick (MVP - Excel)


"Jacob Skaria" <(E-Mail Removed)> wrote in message
news:3E43EF90-D8E8-4BEC-A14A-(E-Mail Removed)...
> Try this.....it was too long...
>
> Range(Cells(ActiveCell.Row, ActiveCell.Column), _
> Cells(ActiveCell.Row + 10, ActiveCell.Column + 6)).Select
>
>
> If this post helps click Yes
> ---------------
> Jacob Skaria
>
>
> "J.W. Aldridge" wrote:
>
>> Mr. Jacob, that didn't work...
>>

Thanks Rick..

If this post helps click Yes
---------------
Jacob Skaria


"Rick Rothstein" wrote:

> This is much easier to do using the Resize property of the Range object (the
> ActiveCell in this case)...
>
> ActiveCell.Resize(11, 7).Select
>
> where the 11 and 7 are one more than the number of rows and columns to add
> (the one being so that the 10 and 6 are in addition to the ActiveCell's row
> and column).
>
> --
> Rick (MVP - Excel)
>
>
> "Jacob Skaria" <(E-Mail Removed)> wrote in message
> news:3E43EF90-D8E8-4BEC-A14A-(E-Mail Removed)...
> > Try this.....it was too long...
> >
> > Range(Cells(ActiveCell.Row, ActiveCell.Column), _
> > Cells(ActiveCell.Row + 10, ActiveCell.Column + 6)).Select
> >
> >
> > If this post helps click Yes
> > ---------------
> > Jacob Skaria
> >
> >
> > "J.W. Aldridge" wrote:
> >
> >> Mr. Jacob, that didn't work...
> >>
>
>