And if you had:

dim v(-12 to 32, 372 to 424)

it would be even more difficult for lots of humans, well, at least me.



Dana DeLouis wrote:

Hi. Well, maybe that wasn't a good example. :)
What I was thinking was something along this line...

Dim v(1 To 189, 1 To 127)

1: Range("AF143:FA330") = v
2: Range("AF143").Resize(189, 127) = v

Both options put the array 'v' into the spreadsheet.
For me, I have a "hard" time looking at option 1 as telling if it is
correct.
In fact, it's off by 1 in both dimensions.
Again, it was just another option for the op.
--

Dana DeLouis
Windows XP, Office 2003

"Robert ap Rhys" <killerthewhale [at] yahoo [dot] com wrote in message
...

Hi Dana,


Another option to this excellent idea is to use Resize.

A very good option. Much more intuitive to those not ingrained in doing it
the other way. You just need to be aware that the Resize property doesn't
actually /Resize/ anything, but returns a completely different range
object.
Why use a verb for a property name, MS?

This lets Excel do
the hard math...

What values of 'hard' are you using? ;-)

Rob

--

Dave Peterson