how to get an array of addresses from a range

[dukenuke]

Hi there,
I have a little Problem, and I don't know how to solve it

I have a table that looks like this:

| A | B | C | D | ...
1 | fu | bar | lab |...
2 | rab| uf | luv |...
3 |...
...

All of my values are within the Range "A1:C2"

I would like to have a variant array which contains the addresses of this range.

Things I tried that didn't work:

If my variant is V and my range is R,


v = r returns an array which contains
fu|bar|lab
rab|uf |luv

V = R.Address gives me
A1:C2|A1:C2|A1:C2
A1:C2|A1:C2|A1:C2


What I actually want:
A1|B1|C1
A2|B2|C2


i know this can easily be done with a loop, but the table I want to use this on is huge, and a loop takes hours to execute, that's why I am looking for a way to do this in one step.

Can anybody help? (please)

[ragulduy]

Only thing I can think of without a loop would be something like:

Please Login or Register  to view this content.

Why do you need to do this though?