Hi,

I was trying to past an array into cells. And one way in the excel book
suggested the
following. But it was not working, could not figure out why.
I am using excel 2002.

Set TheRange = Range(Cells(1, 3), Cells(100, 3))

TheRange.Value = EOY_FUND

EOY_FUND is a 1x100 matrix

Thanks for you help.