Range.Select with variable cells ?  
Author Message
rhcp





PostPosted: Wed Oct 29 14:34:06 CST 2003 Top

Excel Programming >> Range.Select with variable cells ?

Hello,

I am having a devil of a time trying to find out how to use Range.Select
(or something else) with rows and columns that vary.

row1 = x1
row2 = x2
col1 = y1
col2 = y2

x1=1
x2=2
y1=1
y2=2


Range(R[x1]C[y1]:R[x2]C[y2]).Select

or

Range(R[x1]C[y1+1]:R[x1]C[y2+2]).Select

is what I am trying to accomplish but I keep getting errors.
How do I use the Range statement (or something else) in the
above statements?


Lance

Excel297  
 
 
Ron





PostPosted: Wed Oct 29 14:34:06 CST 2003 Top

Excel Programming >> Range.Select with variable cells ? Try this

Sub test()
x1 = 1
x2 = 2
y1 = 1
y2 = 2

Range(Cells(x1, y1), Cells(x2, y2)).Select
End Sub


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl




> Hello,
>
> I am having a devil of a time trying to find out how to use Range.Select
> (or something else) with rows and columns that vary.
>
> row1 = x1
> row2 = x2
> col1 = y1
> col2 = y2
>
> x1=1
> x2=2
> y1=1
> y2=2
>
>
> Range(R[x1]C[y1]:R[x2]C[y2]).Select
>
> or
>
> Range(R[x1]C[y1+1]:R[x1]C[y2+2]).Select
>
> is what I am trying to accomplish but I keep getting errors.
> How do I use the Range statement (or something else) in the
> above statements?
>
>
> Lance
>