Running Access-to-Excel Automation....

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run-time error 1004 paste method of worksheet class failed 3
Macro to run on hidden sheet 4
Copy of VB code to new spreadsheet 6
How to macro to relative position 6
End Down a second time 1
Looping Macro 5
Macro to copy/paste from one workbook to another 8
copy paste values macro 5

Back
Top