G Guest Jan 7, 2004 #1 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.
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 Jan 7, 2004 #2 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.
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.
G Guest Jan 7, 2004 #3 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?
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 Jan 7, 2004 #4 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?
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?
