Results 1 to 5 of 5

Thread: Create A Dynamic Border Using Excel Native Formula

  1. 06-01-2013, 11:07 PM #1
    mahmoud-lee
    mahmoud-lee is offline
    Senior Member
    Join Date
    Mar 2013
    Posts
    146
    Rep Power
    0

    Create A Dynamic Border Using Excel Native Formula

    Can I do this frame in any place and any cell by formula
    Attached Files Attached Files
    Last edited by mahmoud-lee; 06-01-2013 at 11:31 PM.
    Reply With Quote Reply With Quote
  2. 06-02-2013, 12:18 AM #2
    Rick Rothstein
    Rick Rothstein is offline
    Forum Guru Rick Rothstein's Avatar
    Join Date
    Feb 2012
    Posts
    659
    Rep Power
    13
    Put this formula in A1 and copy it across to O1, then copy A1:O1 down as far as you will want the rows to ever be filled to...

    =IF(OR(ROW()>$Q$1,COLUMN()>$P$1),"",IF(OR(ROW()=1, ROW()=$Q$1),REPT($R$1,2),IF(OR(COLUMN()=1,COLUMN() =$P$1),REPT($R$1,2),"")))
    Reply With Quote Reply With Quote
  3. 06-02-2013, 02:33 AM #3
    mahmoud-lee
    mahmoud-lee is offline
    Senior Member
    Join Date
    Mar 2013
    Posts
    146
    Rep Power
    0
    Great ..Great
    You are a genius
    Last edited by mahmoud-lee; 06-02-2013 at 02:40 AM.
    Reply With Quote Reply With Quote
  4. 06-02-2013, 05:56 AM #4
    Rick Rothstein
    Rick Rothstein is offline
    Forum Guru Rick Rothstein's Avatar
    Join Date
    Feb 2012
    Posts
    659
    Rep Power
    13
    You have overstated my abilities by quite a lot, but I do appreciate the sentiment, so I will simply say "thank you".
    Reply With Quote Reply With Quote
  5. 06-02-2013, 06:07 AM #5
    mahmoud-lee
    mahmoud-lee is offline
    Senior Member
    Join Date
    Mar 2013
    Posts
    146
    Rep Power
    0
    "thank you"
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Excel Dynamic Waterfall Chart
    By Excel Fox in forum Excel and VBA Tips and Tricks
    Replies: 2
    Last Post: 10-08-2015, 05:33 PM
  2. Use Native Excel Function Lookup Formula In VBA
    By ramananhrm in forum Excel Help
    Replies: 8
    Last Post: 05-03-2013, 09:10 AM
  3. Automatically Create Multiple Dynamic Named Ranges Using VBA
    By Rajan_Verma in forum Rajan Verma's Corner
    Replies: 0
    Last Post: 04-24-2013, 03:49 PM
  4. Combining Functions To Create Array Formula
    By Ryan_Bernal in forum Excel Help
    Replies: 3
    Last Post: 01-07-2013, 12:38 PM
  5. Concatinate values in a Range or Array using Native Formula
    By LalitPandey87 in forum Excel Help
    Replies: 3
    Last Post: 04-08-2012, 09:44 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
  •  

Forum Rules