+ Reply to Thread
Results 1 to 6 of 6

modify existing macro to have more ranges

  1. #1
    Forum Contributor
    Join Date
    12-17-2012
    Location
    indonesia
    MS-Off Ver
    Excel 2019
    Posts
    170

    modify existing macro to have more ranges

    Hi Please kindly help,

    for below macros is that possible to widened the ranges, now only applied to column AR , I would like the ranges from column AP - AT, thx

    Please Login or Register  to view this content.

  2. #2
    Forum Expert
    Join Date
    12-10-2006
    Location
    Sydney
    MS-Off Ver
    Office 365
    Posts
    3,523

    Re: modify existing macro to have more ranges

    Hi oeyandyprawira;

    Try this:

    Please Login or Register  to view this content.
    Regards,

    Robert
    ____________________________________________
    Please ensure you mark your thread as Solved once it is. Click here to see how
    If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post

  3. #3
    Forum Contributor
    Join Date
    12-17-2012
    Location
    indonesia
    MS-Off Ver
    Excel 2019
    Posts
    170

    Re: modify existing macro to have more ranges

    Hi Trebor76,

    thx it work to widened the range , but the result is wrong

    because on original code is for column AR, when processing column AP code should be
    Please Login or Register  to view this content.
    and so on when reach column AT will be -41


    original code below on column AR
    Please Login or Register  to view this content.
    Last edited by oeyandyprawira; 12-15-2018 at 09:34 PM.

  4. #4
    Forum Expert
    Join Date
    12-10-2006
    Location
    Sydney
    MS-Off Ver
    Office 365
    Posts
    3,523

    Re: modify existing macro to have more ranges

    Just need to tweak the column number of the cl variable like so:

    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    12-17-2012
    Location
    indonesia
    MS-Off Ver
    Excel 2019
    Posts
    170

    Re: modify existing macro to have more ranges

    perfect trebor76, thx

  6. #6
    Forum Expert
    Join Date
    12-10-2006
    Location
    Sydney
    MS-Off Ver
    Office 365
    Posts
    3,523

    Re: modify existing macro to have more ranges

    You're welcome. Thanks for marking the thread as solved and the rep

+ 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] modify existing macro to remove "e" to have more ranges
    By oeyandyprawira in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-15-2018, 08:32 PM
  2. [SOLVED] Modify existing macro to identify correct filter and tab
    By mark888 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-27-2017, 10:39 AM
  3. Modify existing macro to extend action to another column
    By MikeWaring in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-14-2014, 03:40 PM
  4. Replies: 2
    Last Post: 11-03-2014, 12:06 PM
  5. [SOLVED] Modify an existing macro to not copy to the same workbook but another one.
    By DaVihm in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-29-2013, 02:11 AM
  6. Modify existing macro to transpose results
    By Cody1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-03-2013, 09:29 AM
  7. Modify existing averaging macro for efficiency
    By Counse in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-09-2011, 04:56 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