RockMechMark
10-03-2012, 10:14 AM
I perform the following in a Do loop:
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Each time the loop comes to this statement, execution of the subroutine pauses and a window with Yes/No buttons pops up. The question in the window is "Do you want to replace the contents of the destination cells?"
My answer is always yes, but I want this macro to execute unattended. I have not found a setting yet that will suppress this pause and the question. I ask for assistance from the VBA world. You are great.
Mark
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Each time the loop comes to this statement, execution of the subroutine pauses and a window with Yes/No buttons pops up. The question in the window is "Do you want to replace the contents of the destination cells?"
My answer is always yes, but I want this macro to execute unattended. I have not found a setting yet that will suppress this pause and the question. I ask for assistance from the VBA world. You are great.
Mark