| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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") |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Strange behavior when calculate two or more cells | Excel Worksheet Functions | |||
| Need Help: Strange, Strange Behavior ( Not Me. My Model! ) | Excel Programming | |||
| PERCENTRANK in array formula: strange behavior | Excel Discussion (Misc queries) | |||
| Strange behavior in INDEX(..., MIN(...)) - array formula | Excel Discussion (Misc queries) | |||
| Strange behavior. | Excel Discussion (Misc queries) | |||
![CompleteNewb[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
