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

Originally Posted by jindon

Array from the range MUST be variant type.

Because it should hold various types of elements like numeric/string/boolean as Cell does.

Hi jindon…

Ok. Many Thanks. If I think about it the Elements become a string by .Value, which is after the Range Object. So as that Object is initially assigned to the Array the Dimensioning must allow for that. There are a few similar anomalies in size Dimensioning etc. I do not quite grasp. But I will not hijack the Op’s Thread. I will have a good think again and then possibly start a thread in the Beginners “New Users/Basics” Forum
Thanks Again.
Alan