How to use variables for Range( ) ?

S

serdar

Lets say my starting and ending coordinate variables are (x1,y1) and
(x2,y2).


I want to define a Range from (x1,y1) to (x2,y2). Range( ) accepts string
datatype so i cannot use variables in Range( ). I cannot use Cells ( ) cos
it defines a single cell only.
 
S

serdar

Sorry for bothering you, i guess this is the answer:

Range(Cells(x1, y1), Cells(x2, y2))
 
Top