Run-Time error '1004'

A

acjosh

I am getting Run-Time error '1004': PasteSpecial method of Range class
failed when I run the macro on my computer. When I run it on someone
elses it works. Also, when I get the error if I hit Debug and then hit
run, it works. Any ideas? Here's some of the code:

'Copy stuff from Internet Explorer here
XXXX
'Clear the current contents of the paste section and then paste
Sheets("Successful Uploads").Activate
Sheets("Successful Uploads").Range("A:E").ClearContents
Worksheets("Successful Uploads").Range("A1").PasteSpecial
Application.CutCopyMode = False

I have ensured that under TOOLS / MACRO / SECURITY / TRUST SOURCES that
the Trust Access to Visual Basic Project is checked.
 
Top