Range.Cut Paste on NewSheet
Hi Gang,
No surprise I am having a moment here. I am trying to cut some data & paste it on a new sheet. I am doing that successfully.
I would like your help with doing it in a few less lines/steps. Heres myCode:
I added one comment in there I would like to also know how I can get back to mySheet "Old". If I cant, & thats what I gotta do; thats fine Im over it already.
Please Login or Register to view this content.
TIA
Last edited by dlow; 03-20-2015 at 12:47 AM.
When you add a sheet that sheet becomes the active sheet, that is why you need to select the old sheet
Hi Dave,
Thanks that what I was thinking, but wasnt sure, so in this type of situation its ok to select an object, got it.
Now could some put me in my place & tell me if this code snippet below is as good as it gets or can it be cut-down/consolidated more.
What I was trying to do is:Please Login or Register to view this content.
But, I cant get it to work, that doesnt mean it can be done, just that I dont know what Im doing or how to do it.Please Login or Register to view this content.
There can be many variations to make this work.....
Here's one, you can change it to .cut if you need to.
Please Login or Register to view this content.
Last edited by davesexcel; 03-21-2015 at 08:27 AM.
Hi dave that is really cool & so are you thx a lot for your help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks