Selecting multi rows

[Derek Mansfield]

I wish to select rows from row FstRw to row LstRw where FstRw and LstRw are
established by my previous code. I can only find reference to selecting a
single row as a variable and multi rows by fixed row numbers. Any help
would be much appreciated.
Thanks
Derek Mansfield

[Ron de Bruin]

Hi Derek

Try this

frow = 12
Lrow = 20
Rows(frow & ":" & Lrow).Select



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Derek Mansfield" <delhm@nospam_blueyonder.co.uk> wrote in message news:[email protected]...
>I wish to select rows from row FstRw to row LstRw where FstRw and LstRw are
> established by my previous code. I can only find reference to selecting a
> single row as a variable and multi rows by fixed row numbers. Any help
> would be much appreciated.
> Thanks
> Derek Mansfield
>

[Bob Phillips]

Range("A" & FstRw).Resize(LstRw - FstRw + 1).Select

or

Range(Cells("A" & FstRw), Cells(LstRw,"A"))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Derek Mansfield" <delhm@nospam_blueyonder.co.uk> wrote in message
news:[email protected]...
> I wish to select rows from row FstRw to row LstRw where FstRw and LstRw
are
> established by my previous code. I can only find reference to selecting a
> single row as a variable and multi rows by fixed row numbers. Any help
> would be much appreciated.
> Thanks
> Derek Mansfield
>
>

[Derek Mansfield]

Hi Ron,
Thanks very much. Exactly what I was looking for.
Regards,
Derek Mansfield

"Ron de Bruin" wrote:

> Hi Derek
>
> Try this
>
> frow = 12
> Lrow = 20
> Rows(frow & ":" & Lrow).Select
>
>
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
> "Derek Mansfield" <delhm@nospam_blueyonder.co.uk> wrote in message news:[email protected]...
> >I wish to select rows from row FstRw to row LstRw where FstRw and LstRw are
> > established by my previous code. I can only find reference to selecting a
> > single row as a variable and multi rows by fixed row numbers. Any help
> > would be much appreciated.
> > Thanks
> > Derek Mansfield
> >
>
>
>