View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Kevin B
 
Posts: n/a
Default Running Access-to-Excel Automation....

Add the following line above your paste command:


Application.DisplayAlerts = False

--
Kevin Backmann


"Bob Barnes" wrote:

Rarely, when this cose is run...

Range("DTop").Select
...Occurs directly below....
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False

I get...
"Do you want to replace the contents of the destination cells?"

What causes this, & how can it be turned OFF?

TIA - Bob