Solved

i am running excel macro and i receiving the attach error

Posted on 2014-10-23
5
119 Views
Last Modified: 2014-11-03
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
Comment
Question by:gvilbis
  • 2
  • 2
5 Comments
 
LVL 35

Assisted Solution

by:Kimputer
Kimputer earned 250 total points
ID: 40399017
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
 
LVL 24

Assisted Solution

by:Phillip Burton
Phillip Burton earned 250 total points
ID: 40399027
Would the same error arise if you use Paste, instead of PasteSpecial?
0
 

Author Comment

by:gvilbis
ID: 40399082
i just run it on diffrent user and its running OK
but for specific user i am getting this error
0
 
LVL 24

Assisted Solution

by:Phillip Burton
Phillip Burton earned 250 total points
ID: 40399096
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
 
LVL 35

Accepted Solution

by:
Kimputer earned 250 total points
ID: 40399111
Is the code based on more excel files? (Copy something from one excel file to another)
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question