View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bob Barnes
 
Posts: n/a
Default Running Access-to-Excel Automation....

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