VBA pasting array into cells

J

Jeff

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.
 
D

Dave Peterson

Maybe...

TheRange.Value = Application.Transpose(EOY_FUND)

Would work ok for you.
 
Top