Cell identification in x,y coordinates

F

FutureWiz

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.
 
C

Chip Pearson

Use the Cells property. E.g.,

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


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


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

FutureWiz

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?
 
C

Chip Pearson

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


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




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