Ranges and Arrays - Passing values
Hi again,
Sorry to have bothered you but Problem solved. e.g.
Range("C5:F13").Value = TestArray
Thanks and 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
|