Cell identification in x,y coordinates
 

Does anyone know if a cell can be identified in x,y coordinates such as Range("x,y"). Where as Range("1,1") would be cell A1.

Cell identification in x,y coordinates
 

Use the Cells property. E.g.,

Worksheets("Sheet1").Cells(1,2)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"FutureWiz" wrote in
message
...
Does anyone know if a cell can be identified in x,y coordinates
such as Range("x,y"). Where as Range("1,1") would be cell A1.

Cell identification in x,y coordinates
 

Thanks for the reply, have been looking at some other solutions as well. ie. Range("RxCy") where x and y are real numbers being minipulated by loop. Will this work?

Cell identification in x,y coordinates
 

No, that will not work. Use the Cells property.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"FutureWiz" wrote in
message
...
Thanks for the reply, have been looking at some other solutions
as well. ie. Range("RxCy") where x and y are real numbers being
minipulated by loop. Will this work?