+ Reply to Thread
Results 1 to 3 of 3

Macro creating worksheet correctly but inserting it in the wrong place

  1. #1
    Registered User
    Join Date
    01-11-2017
    Location
    Chicago, IL
    MS-Off Ver
    2010
    Posts
    80

    Macro creating worksheet correctly but inserting it in the wrong place

    Can someone please tell me why the macro is inserting the new Master worksheet before the RTT AVAIL AVE sheet? It should be putting it before the SOLD AVE sheet.

    Thanks,
    Amy
    Attached Files Attached Files

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Macro creating worksheet correctly but inserting it in the wrong place

    Not when I run the macro does it do that. It puts the renamed Master sheet FEB20-FEB26 before the SOLD AVE sheet
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    01-11-2017
    Location
    Chicago, IL
    MS-Off Ver
    2010
    Posts
    80

    Re: Macro creating worksheet correctly but inserting it in the wrong place

    Weird. Could it be that I have temporary files interfering?

+ 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. [SOLVED] Help with a macro - can't get worksheet in right place
    By candymycandy in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 09-17-2019, 11:05 AM
  2. [SOLVED] Creating and Inserting a Macro into a New Workbook
    By brentjohn in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-06-2019, 10:01 AM
  3. Replies: 7
    Last Post: 10-14-2018, 11:47 AM
  4. [SOLVED] Macro enabled worksheet not performing correctly
    By ArtZ in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-03-2016, 07:07 PM
  5. Help creating a Combo Macro to place data into another cell
    By Darth269 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-05-2012, 08:15 AM
  6. Macro not working correctly, what did I do wrong?
    By soreno in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-12-2010, 03:36 PM
  7. place button correctly
    By narang.mohit in forum Excel General
    Replies: 1
    Last Post: 03-31-2009, 01:59 PM

Tags for this Thread

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