+ Reply to Thread
Results 1 to 2 of 2

Including a special line in my border's macro

  1. #1
    Forum Contributor
    Join Date
    11-20-2009
    Location
    Melbourne
    MS-Off Ver
    Excel 2013
    Posts
    237

    Including a special line in my border's macro

    I was graciously provided with the following code (by PCI) which would allow me to highlight any part of my spread sheet and apply the borders I wanted.
    Please Login or Register  to view this content.
    I have discovered that with all my selections that I need to place a different border type on the 4th cell down and across how ever many columns.
    Is there something that can be inserted into the above code to do this each time.
    I have attached a sample of what I need just to clarify. Thank you for any assistance anyone can offer.
    Borders.xlsx

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Including a special line in my border's macro

    Hello coach.32,

    This worked for me.

    Please Login or Register  to view this content.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

+ 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. Replies: 1
    Last Post: 05-12-2014, 03:21 AM
  2. Special border
    By mattress58 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-18-2013, 02:07 PM
  3. [SOLVED] Macro to add blank row with border line on top
    By STU22 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-26-2013, 08:11 PM
  4. Export multiple columns to single column text files including special characters
    By mike4uuu in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-09-2011, 04:54 AM
  5. [SOLVED] 10 000 Line, every 2 Lines need a border and a open line inbet. e.
    By annalie in forum Excel General
    Replies: 2
    Last Post: 01-30-2006, 11:20 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