I know that I can make excel ranges = to other excel ranges if they have
the same dimensions. Assume ActiveColumn is a 100X1 (r,c) excel array.
Below I can make this range equal to an offset of itself


Range("ActiveColumn") = Range("ActiveColumn").Offset(0, 1).Value

But what happens if I want to make that range equal to a part of a VBA
array. Say the VBA Array is called DataArray. And also assume that
DataArray is 100x100. Is there any way I can make ActiveColumn = to a
portion of the array without using a Loop?


---
Message posted from http://www.ExcelForum.com/