Copy Data to a New Worksheet From Array

[JStellato]

Hello,

I have this code:

Range("E1").Resize(UBound(MyArray, 1), UBound(MyArray, 2)) = MyArray

Which copies the data from the array into the same worksheet it came from. What I would like to do, is have this line export the data to a new worksheet.

Thanks!

 

[mirabeau]

What I would like to do, is have this line export the data to a new worksheet.

Do you mean like this?

Sub copytonewsheet()
With Sheets.Add
    .Name = "newworksheet"
    .Range("E1").Resize(UBound(Myarray, 1), UBound(Myarray, 2)) = Myarray
End With
End Sub

Although note that MyArray should be an array of values, not a worksheet object.

 

[JStellato]

Yes this was what I was looking for thanks!