Hi again Dave,
Unfortunately that's one of the things I've tried. In fact I've still got it in in the mini macro I'm using to tease the problem out, but it hasn't helped. Should have posted it in the code, really, sorry about that.
Just to check the line I have works, it's:
Workbooks("data.xls").Worksheets("Sheet1").Activate
Kate
This may help (or not); tryu replacing this codewith
Selection.PasteHope this helps.Selection.PasteSpecial
J
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
KateMolloy 
Register To Reply
Bookmarks