copy array to range

  • Thread starter Thread starter Stefi
  • Start date Start date
S

Stefi

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
 
Back
Top