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 ***

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

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


"Kalle" wrote:

>
> 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 ***
>

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("A1:P1000")

End Sub


--


Gary

"Kalle" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>
> 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 ***

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

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