• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 125
  • Last Modified:

i am running excel macro and i receiving the attach error

in the debug it failing on the following line:
ThisWorkbook.Worksheets("Sheet1").Range("A1").PasteSpecial Paste:=xlPasteAll ', Paste:=xlPasteComments
its happen only for specific user and for other login users who running a copy of this file the error is not happen

please advice
Thanks
Gvilbis
excel-run-time-error.JPG
0
gvilbis
Asked:
gvilbis
  • 2
  • 2
4 Solutions
 
KimputerCommented:
Strange error, no solution.
Only one piece of advice, try to update your attachment (remove IP numbers visible)
Incidentally, I also use the same port number for that purpose :)
0
 
Phillip BurtonDirector, Practice Manager and Computing ConsultantCommented:
Would the same error arise if you use Paste, instead of PasteSpecial?
0
 
gvilbisAuthor Commented:
i just run it on diffrent user and its running OK
but for specific user i am getting this error
0
 
Phillip BurtonDirector, Practice Manager and Computing ConsultantCommented:
My best guess then: There is a problem with the installation of Excel or Windows on that computer, something which affects the clipboard.

I would suggest a detect and repair on MS Office.
0
 
KimputerCommented:
Is the code based on more excel files? (Copy something from one excel file to another)
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now