+ Reply to Thread
Results 1 to 5 of 5

Range.Cut Paste on NewSheet

  1. #1
    Forum Contributor dlow's Avatar
    Join Date
    08-12-2013
    Location
    EveryWhere
    MS-Off Ver
    Excel 2007, 2010
    Posts
    275

    Lightbulb 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:
    Please Login or Register  to view this content.
    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.

    TIA
    Last edited by dlow; 03-20-2015 at 12:47 AM.

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,473

    Re: Range.Cut Paste on NewSheet

    When you add a sheet that sheet becomes the active sheet, that is why you need to select the old sheet

  3. #3
    Forum Contributor dlow's Avatar
    Join Date
    08-12-2013
    Location
    EveryWhere
    MS-Off Ver
    Excel 2007, 2010
    Posts
    275

    Re: Range.Cut Paste on NewSheet

    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.
    Please Login or Register  to view this content.
    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.

  4. #4
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,473

    Re: Range.Cut Paste on NewSheet

    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.

  5. #5
    Forum Contributor dlow's Avatar
    Join Date
    08-12-2013
    Location
    EveryWhere
    MS-Off Ver
    Excel 2007, 2010
    Posts
    275

    Re: Range.Cut Paste on NewSheet

    Hi dave that is really cool & so are you thx a lot for your help.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Loop through files in folder, copy range, Paste range to original workbook
    By knevil in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 03-09-2016, 05:33 PM
  2. Copy Data between 2 dates and paste it newsheet
    By Knowledge is Wealth in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-10-2013, 09:57 AM
  3. Change range of cells within VBA macro and copy and paste to fixed cell range
    By Mannyny in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-20-2012, 11:51 AM
  4. set NewSheet = OldSheet.copy
    By eclapt in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-09-2009, 11:00 AM
  5. Replies: 5
    Last Post: 09-19-2008, 04:02 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1