Thread: Paste Array
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jeff Jeff is offline
external usenet poster
 
Posts: 921
Default Paste Array

Hi,

I have an array

Array(750,200)

I want to paste the contents into the worksheet, i tried

Sheets("Sheet1").Range("C1:GU750").Value =
Application.WorksheetFunction.Transpose(Array)

but this didnt work, I guess because of transpose?

Is there a way to output a 2x2 array automatically?

Thanks for your help!!!