+ Reply to Thread
Results 1 to 4 of 4

Recorded Macro for Excel Table doesn't work when run again

  1. #1
    Valued Forum Contributor saravnepali's Avatar
    Join Date
    01-14-2019
    Location
    Sydney Australia
    MS-Off Ver
    2010
    Posts
    422

    Recorded Macro for Excel Table doesn't work when run again

    Hi,

    I tried to record a macro with Excel.

    It has to select a table, sort and filter values based on date - simple operation.

    The macro is recorded properly.

    But, when I tried to run recorded macro again it doesn't run the way it should. It filters all data and doesn't display any data.

    I have not amended any code on the macro after I have recorded it and no changes on the excel data either. But it simply doesn't work.

    Am I missing something in here.
    Please Login or Register  to view this content.
    I have attached the excel file and also the screen shots for what I achieved with the macro running as well.
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by saravnepali; 11-14-2019 at 08:45 PM.
    If you think someone helped you, click on the "* Add Reputation" as a way to say thank you.

    If your problem is solved, go to Thread Tools and select Mark This Thread Solved

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019
    Posts
    18,495

    Re: Recorded Macro for Excel Table doesn't work when run again

    cannot replicate your issue. Macro works fine for me on your unfiltered table. Filters properly.

  3. #3
    Valued Forum Contributor saravnepali's Avatar
    Join Date
    01-14-2019
    Location
    Sydney Australia
    MS-Off Ver
    2010
    Posts
    422

    Re: Recorded Macro for Excel Table doesn't work when run again

    Quote Originally Posted by alansidman View Post
    cannot replicate your issue. Macro works fine for me on your unfiltered table. Filters properly.
    It seems that earlier file wasn't saved properly, so wrong file got uploaded.

    Can you please check now.

  4. #4
    Valued Forum Contributor WasWodge's Avatar
    Join Date
    08-02-2010
    Location
    Hampshire,England
    MS-Off Ver
    Office 365 and Office 2010
    Posts
    880

    Re: Recorded Macro for Excel Table doesn't work when run again

    What happens with...

    Please Login or Register  to view this content.
    or

    Please Login or Register  to view this content.
    Last edited by WasWodge; 11-14-2019 at 08:47 PM.
    If my solution worked (or not) please let me know. If your question is answered then please remember to mark it solved

    Computers are like air conditioners. They work fine until you start opening windows. ~Author Unknown

+ 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] Macro doesn't work in Table
    By BDD2015 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-28-2018, 10:25 AM
  2. [SOLVED] Working Formula Entered in Recorded Macro doesn't work when run!
    By EnigmaMatter in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-24-2014, 11:07 AM
  3. Recorded macro - doesn`t work
    By Bandini in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-12-2014, 02:20 AM
  4. [SOLVED] Copying filtered table doesn't work as it is expected in Excel 2010
    By abbassi in forum Excel General
    Replies: 2
    Last Post: 06-29-2014, 01:57 AM
  5. [SOLVED] Recorded Pivot Table Macro Doesn't Do What I Recorded!
    By diakonos1984 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-26-2013, 11:01 AM
  6. [SOLVED] Recorded macro doesn't work 5 seconds after creation...
    By Bjordion in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-22-2013, 04:51 PM
  7. Recorded macro doesn't seem to provide expected result
    By Jeroen1000 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-21-2009, 06:52 AM

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