Replace this...
Range("A2:A20").Copy Destination:=Found.Offset(1)
With this...
Found.Offset(1).Resize(19).Value = Range("A2:A20").Value
Replace this...
Range("A2:A20").Copy Destination:=Found.Offset(1)
With this...
Found.Offset(1).Resize(19).Value = Range("A2:A20").Value
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks