+ Reply to Thread
Results 1 to 3 of 3

Help needed macro not working

  1. #1
    Registered User
    Join Date
    10-28-2013
    Location
    Denver, CO
    MS-Off Ver
    Excel 2010
    Posts
    5

    Help needed macro not working

    Hi all,
    I am running a simple formatting macro which worked just fine in 2010, but here in 2016 is giving me some really funky results. I am using the Macro Recorder and not using relative. When all said and done the spreadsheet moved most all columns far to the right when I never had it insert columns on the HTR tab. Can someone take a look I have attached the raw test data with the Macro I setup and please help me fix my code? The Med Admin tab seems to have worked, it is the HTR tab that is throwing me off.
    Also, once this is corrected, it would be nice to have on both tabs the auto filter pre populated and sorted by "CHARGE NOT FOUND" and on the HTR tab auto filter and sorted "ORDER NOT FOUND".

    I have seriously tried this 30 times and I do not know why the HTR tab is acting funny.

    Thanks for the assistance.
    KT
    Attached Files Attached Files
    Last edited by Knilsen; 08-17-2017 at 04:07 PM. Reason: Title

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    11,323

    Re: Excel 2016

    title updated....
    Last edited by protonLeah; 08-17-2017 at 08:24 PM.
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    10-28-2013
    Location
    Denver, CO
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Excel 2016

    Corrected, thank you.

+ 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. Replies: 0
    Last Post: 07-05-2017, 09:03 PM
  2. [SOLVED] need help with IF in excel 2016
    By techmaster29729 in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 06-18-2017, 01:41 AM
  3. Replies: 20
    Last Post: 10-19-2016, 06:05 AM
  4. [SOLVED] VBA and Excel 2016
    By Saturn in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-06-2016, 12:35 PM
  5. Replies: 2
    Last Post: 05-24-2016, 10:43 PM
  6. Had custom toolbar in older Excel for Mac, seeking similar functionality in Excel 2016
    By ianpage in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 2
    Last Post: 05-13-2016, 11:06 AM
  7. Excel 2016 & beyond!
    By jewelsharma in forum The Water Cooler
    Replies: 6
    Last Post: 01-10-2016, 05:53 AM

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