Jul 27 2021 12:37 PM
I have created 3 macros with basic copy and paste functions within them. They work perfectly the first time only. Then I get "runtime error 1004" and/or random results, such as moving to another part of the worksheet or pasting partially, in wrong cells.
I have adjusted my security settings to "trust access the VBA project object model" No change.
Any ideas?
Jul 27 2021 02:31 PM
Jul 28 2021 09:53 AM
Jul 28 2021 11:24 AM
Sheets("Sheet1").Range("A1:C1").Copy Range("H1")
The active cell references is probably what's messing this up on your end. If you are looking to just copy and paste using VBA, try the above code. If you change sheet1 to match which sheet you're trying to copy and paste on, change the first "A1:C1" range to whatever you want to copy, and your output cell, "H1" will be where it is pasted. This may work for what you need.
The record macro feature records a lot of unnecessary steps. Let me know if this works.