Replace Cell Values Popup

[helpexcel]

Hi I have a macro that copies data, and when it runs you get a message box asking if you want to replace cell values (this MsgBox is not in my code). How do i stop this from popping up? the answer is always going to be yes. thanks!

 

[Yongle]

Try

 Application.DisplayAlerts = False

[I] your code goes here[/I]

 Application.DisplayAlerts = True

 

[Fluff]

Could you please supply the code?

 

[helpexcel]

Sorry. here's the code. I didn't copy the Sub/Updating part.

   With Sheet31    .Range("AI241:BM246").Copy
    .Range("A17:AE22").PasteSpecial xlPasteValuesAndNumberFormats
    
    .Range("BQ241:CU246").Copy
    .Range("A51:AE56").PasteSpecial xlPasteValuesAndNumberFormats
    End With

 

[helpexcel]

@Yongle That works! thanks!