Hi All,

There is a simple way oy copying a range into an array, e.g.

normatomb = Range("normaszint")

Is there a similarly simple way of copying an array back to a range (other
then looping through the elements of the array)? Something like

normatomb.Copy Destination:=Range("F1")


Thanks,
Stefi

Try

Range("A1:C10").Copy Range("A30")

OR

Dim varTemp As Variant
varTemp = Range("A1:C10")
Range("A11:C20") = varTemp
'with the same dimensions

If this post helps click Yes
---------------
Jacob Skaria


"Stefi" wrote:

> Hi All,
>
> There is a simple way oy copying a range into an array, e.g.
>
> normatomb = Range("normaszint")
>
> Is there a similarly simple way of copying an array back to a range (other
> then looping through the elements of the array)? Something like
>
> normatomb.Copy Destination:=Range("F1")
>
>
> Thanks,
> Stefi
>

Thanks, I was looking for the 2nd way.
Stefi

„Jacob Skariaâ€� ezt Ã*rta:

> Try
>
> Range("A1:C10").Copy Range("A30")
>
> OR
>
> Dim varTemp As Variant
> varTemp = Range("A1:C10")
> Range("A11:C20") = varTemp
> 'with the same dimensions
>
> If this post helps click Yes
> ---------------
> Jacob Skaria
>
>
> "Stefi" wrote:
>
> > Hi All,
> >
> > There is a simple way oy copying a range into an array, e.g.
> >
> > normatomb = Range("normaszint")
> >
> > Is there a similarly simple way of copying an array back to a range (other
> > then looping through the elements of the array)? Something like
> >
> > normatomb.Copy Destination:=Range("F1")
> >
> >
> > Thanks,
> > Stefi
> >