copy worksheet to array

[Kalle]

Hi

I know that it is possible to copy a array t o a worksheet but I can't
find out if it's possible to copy a worksheet into an arry?

Thanks in advance

*** Sent via Developersdex http://www.developersdex.com ***

 

[Joel]

You can copy a Range into an array using the varue property like

myarray = Range("A1:F10").value

 

[Gary Keramidas]

this may be what you're looking for

Sub test()
Dim ws As Worksheet
Dim arr As Variant
Dim rng As Range
Set ws = Worksheets("Sheet1")
arr = ws.Range("A11000")

End Sub

 

[Kalle]

Thanks a lot for your replay. It now works as I want.

*** Sent via Developersdex http://www.developersdex.com ***