How to use variables for Range( ) ?

  • Thread starter Thread starter serdar
  • Start date Start date
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.
 
Sorry for bothering you, i guess this is the answer:

Range(Cells(x1, y1), Cells(x2, y2))
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA looping 1
Find Duplicate Record 1
Combine two records in a table 1
Creating a combined chart 1
Sum of row and column entries (database) 4
How to draw a vertical line in subreport 3
help with matching if 7
One Entry to Multiple Rows 1

Back
Top