+ Reply to Thread
Results 1 to 8 of 8

Apply Border to Main Area

  1. #1
    Forum Contributor delaing's Avatar
    Join Date
    07-16-2010
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    192

    Apply Border to Main Area

    User needs code to apply Thick Border to outline the COMPARABLES area of this sheet.

    Border already exists as needed on three sides in attached sample, but may not always be there and columns/row addresses may change. So, need code that will find the area and apply Thick Border Outline.
    In attached file, it would be A15:M28 area.

    Thank you,
    Delain
    Attached Files Attached Files

  2. #2
    Forum Guru mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,206

    Re: Apply Border to Main Area

    Try
    Please Login or Register  to view this content.
    _
    ...How to Cross-post politely...
    ..Wrap code by selecting the code and clicking the # or read this. Thank you.

  3. #3
    Forum Contributor delaing's Avatar
    Join Date
    07-16-2010
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    192

    Re: Apply Border to Main Area

    Thanks for the quick reply; however, as stated in OP, this is not a static address. It will be a different size range, consisting of varying rows.

    As accomplished in a couple of other similar applications, I can suggest using the label "COMPARABLES" as a reliable landmark for targeting the area needed; along with selecting/applying over to the far-right column and last used row of this area (without including the Notes below).

    Thank you,
    Delain

  4. #4
    Forum Guru
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,122

    Re: Apply Border to Main Area

    Try the attached.
    Attached Files Attached Files

  5. #5
    Forum Contributor delaing's Avatar
    Join Date
    07-16-2010
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    192

    Re: Apply Border to Main Area

    Beautiful . . . . again!!
    Tweaked it just a tad to loosen its use.
    Including here for reference:
    Please Login or Register  to view this content.
    Thank you for the great help,
    Delain

  6. #6
    Forum Contributor delaing's Avatar
    Join Date
    07-16-2010
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    192

    Re: Apply Border to Main Area

    AB33,

    One other thought.
    What can we change in the code shown in #5 that could eliminate the FIND ("INDICATED VALUE PER") step?

    Instead of using that as our far-right landmark, can we simply have it seek .End(xlRight) from the COMPARABLES column, somehow? I'm not sure how to implement.

    Thank you,
    Delain

  7. #7
    Forum Guru
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,122

    Re: Apply Border to Main Area

    You can use this code, but it might not as reliable as the first one.

    Please Login or Register  to view this content.
    Last edited by AB33; 07-06-2016 at 03:55 AM.

  8. #8
    Forum Contributor delaing's Avatar
    Join Date
    07-16-2010
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    192

    Re: Apply Border to Main Area

    Seems to work fine. May be some instances we can use without the other specified column label.

    Thank you,
    Delain

+ 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] Apply border automatically based on Conditional Formatting
    By Lola90 in forum Excel General
    Replies: 4
    Last Post: 10-26-2015, 10:25 AM
  2. Border Around Print Area
    By kmlloyd in forum Excel General
    Replies: 0
    Last Post: 04-19-2011, 11:41 AM
  3. Apply Border based on change in cell value?
    By efeb in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-11-2009, 04:41 PM
  4. Print border around printed area
    By pnocero in forum Excel General
    Replies: 0
    Last Post: 01-14-2008, 12:39 AM
  5. [SOLVED] Apply Border to range when first cell has text.
    By Bill in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-16-2005, 04:05 PM
  6. Apply Border
    By Bill in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-28-2005, 08:05 PM
  7. Apply Border based on last Day of Month
    By Bill in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-22-2005, 03:05 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