On Jan 25, 6:48*pm, "Tim Zych" <tzych@NOSp@mE@RTHLINKDOTNET wrote:
If Start is A1 and End is C2, here are different ways to do it.

Range(Range("A1"), Range("C2")).Select

Range(Cells(1, "A"), Cells(2, "C")).Select

Range(Cells(1, 1), Cells(2, 3)).Select

Range("A1").Resize(2, 3).Select

Range(Range("Start"),Range("End")).Select

--
Tim Zych
SF, CA

------------------



I'm still lost. *I'm trying to get something like RANGE(A1:B4).Select,
but I don't have a predefined range and need to use variables.
Eg. RANGE(Start:End).Select
Can anyone help.
Frank- Hide quoted text -

- Show quoted text -

Thanks Tim. That helps.

Frank