Ranges and Arrays - Passing values
Thank you Dana and Alan for your useful and informative notes.
regards
Don
"Don Lloyd" wrote in message
...
Hi,
I can populate an array from a range quite easily, e.g.
Dim TestArray as Variant
TestArray = Range("C5").CurrentRegion.Value
Is there a way to pass values back to the range in a similar fashion ?
That is, without referring to the individual Array and Cell co-ordinates.
regards,
Don
|