Results 1 to 5 of 5

Thread: Create A Dynamic Border Using Excel Native Formula

  1. #1
    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.

  2. #2
    Forum Guru Rick Rothstein's Avatar
    Join Date
    Feb 2012
    Posts
    662
    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),"")))

  3. #3
    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.

  4. #4
    Forum Guru Rick Rothstein's Avatar
    Join Date
    Feb 2012
    Posts
    662
    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".

  5. #5
    Senior Member
    Join Date
    Mar 2013
    Posts
    146
    Rep Power
    0
    "thank you"

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. Replies: 3
    Last Post: 04-08-2012, 09:44 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •