Return Row Index and Column Index of a Cell in a Range

Originally Posted by Doc.AElstein

Hi jindon…

Ok. Many Thanks. .......few similar anomalies in ....etc. I do not quite grasp. But I will not hijack the Op’s Thread. I ...... possibly start a thread in the Beginners ........

Here is the Link to the Thread I started yesterday, which was quickly solved:
http://www.excelforum.com/excel-new-...to-arrays.html




…………………………………..

Originally Posted by Doc.AElstein

…….. Another possibility would be that the OP wants an Array of Ranges. Again versions of your simple code just in case that is what he wants to do that would be........

. Sorry I got that wrong. My code given here for

Originally Posted by Doc.AElstein

..Array of Ranges.....

actually produces one Range Object for that range E3 – C6.

.
. Just to clear up any confusion, I did a code in that Thread: - ……..
http://www.excelforum.com/excel-new-...to-arrays.html
…………at the end I wrote and described a Macro using Spreadsheet Range C3 – E6 as an example which produces 3 things based on that Spreadsheet Range.
.1) An Array of the values in the cells in that Spreadsheet Range;
.2) One Range Object for That Range;
.3) An Array of all the Cells in that Spreadsheet Range as Range Objects

Hope that clears up any confusion caused by my then ignorance of the different ways of “Capturing” the stuff in a Spreadsheet Range

Alan.