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
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.
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…