View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
CompleteNewb[_2_] CompleteNewb[_2_] is offline
external usenet poster
 
Posts: 30
Default Strange pasting array to cells behavior

Thanks for the help, Jim. It wasn't clicking in my mind that I was using
UBound to set the range's last cell's row number.

Sorry for the silly oversight, and thanks again.


"Jim Cone" wrote in message
...

'---Part One
The upperbound of ElementList is 3
3 +1 = 4
So...
("C3:C" & UBound(ElementList) + 1)
Translates to ...
("C3:C4")