+ Reply to Thread
Results 1 to 4 of 4

Change recorded macro to remove all the selects... trying to learn how.

  1. #1
    Forum Contributor
    Join Date
    05-19-2012
    Location
    houston
    MS-Off Ver
    excel 2013
    Posts
    103

    Change recorded macro to remove all the selects... trying to learn how.

    Hi,

    I'm trying to learn how to rewrite the code from a bunch of recorded macros so it doesn't have all the selects... since I've been reading this is bad. But I haven't been able to get it right yet... so thought I'd ask for some help. Hopefully someone can show me the equivalent to these... and then I'd be able to figure out the rest from there.

    Please Login or Register  to view this content.

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,722

    Re: Change recorded macro to remove all the selects... trying to learn how.

    How about
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    05-19-2012
    Location
    houston
    MS-Off Ver
    excel 2013
    Posts
    103

    Re: Change recorded macro to remove all the selects... trying to learn how.

    Thank you for responding Fluff13... I should have said each one of those 5 codes is a separate macro... so they aren't run/grouped together. But using your code... is this pretty close for each one individually?

    Please Login or Register  to view this content.

  4. #4
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,722

    Re: Change recorded macro to remove all the selects... trying to learn how.

    The 1st two should as I wrote them & the other three should be
    Please Login or Register  to view this content.

+ 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] How to change a recorded macro based on a field value?
    By AccountingJ in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 12-02-2017, 01:57 AM
  2. change recorded macro to vba
    By deek in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-07-2016, 01:16 PM
  3. Change default pie chart colors in recorded macro 2010
    By tutv088 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-21-2014, 10:35 AM
  4. [SOLVED] Need to change a recorded macro/use wildcards
    By Wheelie686 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-17-2012, 12:48 PM
  5. [SOLVED] How to run a recorded macro when cell values change?
    By Clue_Less in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-15-2012, 12:01 PM
  6. How do I change a recorded macro to make it general?
    By excelVBAn00b in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-16-2012, 03:38 PM
  7. [SOLVED] Recorded macro: What happens if I change filename?
    By mas_it_2000@yahoo.com in forum Excel General
    Replies: 2
    Last Post: 01-26-2005, 08:06 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