VBA pasting array into cells
 

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.

VBA pasting array into cells
 

Maybe...

TheRange.Value = Application.Transpose(EOY_FUND)

Would work ok for you.

Jeff wrote:

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.

--

Dave Peterson