+ Reply to Thread
Results 1 to 8 of 8

Select Dynamic Range from bottom up

  1. #1
    Registered User
    Join Date
    10-03-2012
    Location
    Asheville, NC
    MS-Off Ver
    Excel 2010
    Posts
    6

    Question Select Dynamic Range from bottom up

    Near the end of a macro I need to select a range of cells from the ActiveCell then back 4 columns, and up 7 rows.
    So the macro has been chugging along, adding values, calculating cells, and creating a Summary section.
    In this example it ends on cell G129 and I need to go back and add a border around the summary section which begins at cell C122.
    The problem is, the range C122:G129 will change each month. Depending on the data set used to generate the other part of the report this range can be + or - 10 or more rows.

    I'm googling but my google-foo is weak right now.

    Help?

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 VersionVersion 2411 Win 11
    Posts
    24,418

    Re: Select Dynamic Range from bottom up

    It would be helpful to see your current code so that it can be appended properly.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    10-03-2012
    Location
    Asheville, NC
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Select Dynamic Range from bottom up

    And as it often happens..... morning brings clarity that was missing last night. The answer was simple:

    Please Login or Register  to view this content.
    Last edited by alansidman; 08-07-2016 at 07:57 PM. Reason: Please use code tags. I have added them for you

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 VersionVersion 2411 Win 11
    Posts
    24,418

    Re: Select Dynamic Range from bottom up

    Thanks for submitting your solution. If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

  5. #5
    Registered User
    Join Date
    10-03-2012
    Location
    Asheville, NC
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Select Dynamic Range from bottom up

    and then I got stuck, again! So I have successfully selected my range which works out to C122:G129 and added the borders I wanted. Now I need to select a new range two rows up or C120:G121... How do I select a new range? Because the same method does not work! But you who are well versed in this already knew that. Do I need to (What is the opposite of select?) deselect? unselect? discard? the current range before selecting the new?

    Thanks again...

  6. #6
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,655

    Re: Select Dynamic Range from bottom up

    Maybe this?
    Please Login or Register  to view this content.
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

  7. #7
    Registered User
    Join Date
    10-03-2012
    Location
    Asheville, NC
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Select Dynamic Range from bottom up

    Thank you sktneer! That is exactly what I needed.

    Please Login or Register  to view this content.
    Last edited by alansidman; 08-07-2016 at 07:56 PM.

  8. #8
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,655

    Re: Select Dynamic Range from bottom up

    You're welcome! Glad to help.
    Thanks for the feedback.

+ 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. Make 'ActiveSheet.Range("C5:N100").Select' - select a dynamic range of cells
    By white_ross in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-13-2016, 10:00 AM
  2. Thick Bottom Border for Dynamic Print Range
    By Robecca in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-21-2014, 12:04 PM
  3. [SOLVED] removing blank at bottom of dynamic named range
    By HeyInKy in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-12-2014, 01:47 PM
  4. Select last row of a dynamic range
    By Angelfish13 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-24-2013, 07:28 AM
  5. dynamic shifting range, always at bottom of column
    By buckfran in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 08-13-2009, 07:14 PM
  6. How to select a dynamic (?) range?
    By HelenW in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-11-2008, 06:54 AM
  7. [SOLVED] select dynamic range with dynamic start point
    By Juli in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-30-2005, 08:05 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