Cell identification in x,y coordinates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

For Eachcell in Range tranpose comma seperated values to a list in D 4
Range passed to a function - trying to just move through the range 4
Permutations andText to column problem 6
Excel VBA help: Text file formatting 19
Use mouse location to place autoshape via VBA 0
Find x-y coordinates of cell? 2
Setting a code range = coords of the cell containing the function 1
using search function in VBA 4

Back
Top