View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Robert ap Rhys Robert ap Rhys is offline
external usenet poster
 
Posts: 21
Default How to insert array into range


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