Results 1 to 6 of 6

Use of Range and Last row to add borders around cells.

Threaded View

  1. #1
    Registered User
    Join Date
    12-15-2011
    Location
    Charleston, SC
    MS-Off Ver
    Excel 2010
    Posts
    43

    Use of Range and Last row to add borders around cells.

    After searching and reading some other posts similar to what I'm looking to do, I have decided that I could use a little help.

    The code I have right now that does not work is...
    Range("A1:H" & LastRow).Borders.LineStyle = xlContinuous
    What I'm doing to taking a report that is supply in a Word Document and analyzing it in Excel. The macro I have created removes columns that are not needed and inserts a few new ones. The sheet has columns from A:H and I would like to have borders around all cells both empty and with content. However, every time I need to do this the row count will change. I feel that I'm on the right track, but not sure what corrections I need to make for it to work.

    BTW... there is no hurry on this as I'm leaving the office soon and will not return until Monday.

    Thanks in advance.

    Brian
    Last edited by BBoydAnchor; 05-21-2012 at 03:06 PM. Reason: Solved

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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