When the print macro is run, I copy and paste 3 different logos into my form based on the product class that is accepted. This works until the user changes his mind about the class. The original drawing object is still there.
Since they always paste to the same location, I'd like to make the first step be to just remove whichever one is there so that the new one can be pasted.
Here's what I'm doing:
If Range("I5").Value = "Product A" Then
ActiveSheet.Shapes("Picture 27").Select
Selection.Copy
Range("A1").Select
ActiveSheet.Paste
Range("A1:J52").Select
Selection.PrintOut Copies:=1, Preview:=True, Collate:=True
Range("F7").Select
Any thoughts.
Thanks,
A_Pitts
Since they always paste to the same location, I'd like to make the first step be to just remove whichever one is there so that the new one can be pasted.
Here's what I'm doing:
If Range("I5").Value = "Product A" Then
ActiveSheet.Shapes("Picture 27").Select
Selection.Copy
Range("A1").Select
ActiveSheet.Paste
Range("A1:J52").Select
Selection.PrintOut Copies:=1, Preview:=True, Collate:=True
Range("F7").Select
Any thoughts.
Thanks,
A_Pitts