Hi,

I am trying to extract a range reference for one column (looping for all columns) that can be used in an excel formula out of a predefined range in VBA.
So I have a predefined range of say A1:C10 called myRange and I am trying to output "A1:A10", "B1:B10" and "C1:C10" as range references. I have tried Index combined with address (and many other methods) but it doesn't seem to work.