Array copy

[yogeshmaney]

Hi,

Array values from one Data should get copied to another cell of which the cell value provided by user

e.g

Suppose Array has values { 1,2,5,}

In another cell suppose i give value 5
Then in the values of array should get copied from 5th column



regards,

---Yogi

 

[DonkeyOte]

Yogi, if you opt to x-post please have the courtesy to provide links accordingly.

http://www.excelforum.com/excel-general/719544-array-copy.html

 

[pike]

Maybe something like...

a = Array(1, 2, 3, 4, 5)
   Sheets("Sheet13").Cells(1, "A").Resize(UBound(a) + 1, 1) = WorksheetFunction.Transpose

 

[yogeshmaney]

http://www.excelforum.com/excel-general/719587-array-copy.html