I'd like to create a macro that adds a border to the bottom cells (i.e., row) of two dynamic ranges.
e.g., Range 1 is based on this formula: =OFFSET(WorkSheet1!$C$8,0,-1,MATCH(1E+306,WorkSheet1!$C$8:$C$265,1), 16) A macro runs some calculations in this range, deletes some rows, and so on, so the final range may be, for example, B8:Q80. At this point, I'd like to have a macro apply a bottom border to the last row in the range. Any suggestions about how to do this? Thank you. -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
