LinkBack URL
About LinkBacks
KateMolloy 
Try activating a worksheet in wbNew by replacing this:
with this:
With wbNew Cells(1, 1).Select
I've used sheet 1 for an example.With wbNew Sheets(1).activate Cells(1, 1).Select
Try activating a worksheet in wbNew by replacing this:
with this:With wbNew Cells(1, 1).Select
I've used sheet 1 for an example.With wbNew Sheets(1).activate Cells(1, 1).Select
Rule 1: Never merge cells
Rule 2: See rule 1
"Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
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 codewithSelection.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
Register To Reply
Bookmarks