M Mike Jul 23, 2003 #1 Try something like this instead: Sheets("SHIFTS").Range("A20:C28").Value = Sheets ("A3").Range("D1:F9").Value
Try something like this instead: Sheets("SHIFTS").Range("A20:C28").Value = Sheets ("A3").Range("D1:F9").Value
S steve Jul 23, 2003 #2 Just to add. On the destination - you only need to specify a single cell. This avoids the problem of matching areas. Sheets("SHIFTS").Range("A20:C28").Value = _ Sheets("A3").Range("D1").Value steve
Just to add. On the destination - you only need to specify a single cell. This avoids the problem of matching areas. Sheets("SHIFTS").Range("A20:C28").Value = _ Sheets("A3").Range("D1").Value steve
