With and End with, Offset Multiple sheets
Okay so I have this code that copies the contents of one cell (A1) and pastes it into anouther (B1). the next time the code is ran, (A1) will be pasted into (B2)
See Code below:
I have had to change a few things around due to expanding.
Please Login or Register to view this content.
Is there anyway I can do this where The cell that's being copied is on a different sheet than the destination of the paste?
Help please!
Last edited by Crebsington; 08-17-2011 at 10:44 PM. Reason: Solved!!
Does something like the following help?Please Login or Register to view this content.
If you're happy with someone's help, click that little star at the bottom left of their post to give them Reps.
---Keep on Coding in the Free World---
This Is perfect! Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks