This code works fine ... but it paste to A2 I would like it to paste to A1.
I tried removing the " + 1 " but that did not work.
I would like it to paste to A1 always, not go to end of a list, it would just overwrite starting in A1 on "Picks" sheet.
Please Login or Register to view this content.
Last edited by dannac; 12-06-2012 at 04:25 PM.
That code isn't going to just paste in one row, it's going to paste in multiple rows.
Removing +1 should work if you want to start pasting in A1.
Or you could try this.
Please Login or Register to view this content.
If posting code please use code tags, see here.
When removing the +1 it copies only the last row of data to A1.Removing +1 should work if you want to start pasting in A1.
I'll will try your code now .... Thanks
Yours works perfectly ... thank you.
How do I mark as "Solved" ?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks