Results 1 to 3 of 3

Thread: Code to copy the active WS before a specific WS in the WB

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. 11-29-2017, 08:25 AM #1
    Admin
    Admin is offline
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,123
    Rep Power
    10
    @ Rob,

    Please use code tags while posting code. I have added the code tag for you this time.

    try

    Code:
    Worksheets.Add before:=Worksheets("SpecificSheetName")
    Cheers !

    Excel Range to BBCode Table
    Use Social Networking Tools If You Like the Answers !

    Message to Cross Posters

    @ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)
    Reply With Quote Reply With Quote
  2. 11-29-2017, 10:45 AM #2
    ROBJ
    ROBJ is offline
    Junior Member
    Join Date
    Nov 2017
    Posts
    6
    Rep Power
    0
    Thank you

    Sorry about that.

    Cheers

    Rob
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Copy/Paste specific data from different pages of same website using VBA code
    By excel_1317 in forum Excel Help
    Replies: 1
    Last Post: 03-11-2014, 06:03 PM
  2. check if next active row after filter is blank in specific column
    By xander1981 in forum Excel Help
    Replies: 4
    Last Post: 02-04-2014, 05:20 PM
  3. Copy Row To Another Sheet Depending On Existence Of Specific Value In Specific Column
    By peter renton in forum Excel Help
    Replies: 8
    Last Post: 07-01-2013, 03:52 PM
  4. Macro to copy data in specific Columns
    By Howardc in forum Excel Help
    Replies: 0
    Last Post: 04-19-2013, 10:42 AM
  5. don't copy filtered data if no active cells
    By xander1981 in forum Excel Help
    Replies: 29
    Last Post: 11-01-2012, 06:47 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
  •  

Forum Rules