Results 1 to 5 of 5

Range.Cut Paste on NewSheet

Threaded View

  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:
    Sub TempNote_New()
    '////////////////////////////////
    Dim FunLastRow As Long, rng As Range
        Set rng = ActiveSheet.Cells 
            FunLastRow = Last(1, rng) 
    '\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\
    Dim Block As Range
    Set Block = Intersect(Range("N:P"), Range("1:" & FunLastRow))
        With Block.Interior
            .ThemeColor = xlThemeColorAccent2
            .TintAndShade = 0.799981688894314
            .PatternTintAndShade = 0
        End With
        
    Range("N1:P1").Interior.Color = 5296274
        
        Block.Cut
        Sheets.Add After:=Sheets(Sheets.Count)
        ActiveSheet.Paste
        Rows("1:1").Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove
        [A1].FormulaR1C1 = "Blah ..."
    
        Sheets("Old").Select 'How could I get mySheet back to the foreground; "Without".Select/.Activate?
                            Set rng = Nothing: Set Block = Nothing
    End Sub
    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.

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