... Actually ... that's not it ... I simplified the code to test as:
But it doesn't like that either, which I didn't expect ... sorry![]()
Sub AutoShape4_Click() Dim Ws As Worksheet Dim Rng1 As Range, Rng2 As Range Range("N5").Value = 1 Range("Q5").Value = 1 Set Ws = Worksheets("Sheet2") Set Rng1 = Range("C28:C33") Set Rng2 = Ws.Range("C28:C33") ActiveSheet.Rng1.Copy Destination:=Rng2 End Sub
![]()
Bookmarks