Results 1 to 8 of 8

Macro for Automated Borders?

Threaded View

  1. #1
    Forum Contributor
    Join Date
    05-29-2013
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2010
    Posts
    143

    Macro for Automated Borders?

    Hello all,

    What I'm trying to do is create a macro that will automatically create boarders for A3:E8. However, the number of rows will vary so I'm gonna have to create a script that will find the last row and include it in the range. However! Row E, has blanks in it, so I can't use it to find the last row.

    I'm not very familiar with writing VBA, but I'm gonna play around with it. I just wanted to post it on here and see who can figure it out first :P

    What I THINK I have to do is something like this:

    1. I would have to create a function to find the last Row of letter M and store the LETTER value in a var.
    2. Select A3 and then pull the VAR from above... something like Range(A3:Var)


    I don't know if this makes sense. I don't know VBA syntax, otherwise I would have given it a try. I'm gonna study up on it tonight, but I was hoping to get this going today. any help would be appreciated.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Auto change borders to thick borders
    By Pierce Quality in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 11-22-2013, 11:17 PM
  2. [SOLVED] Macro for adding Borders
    By Jiptastic in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-31-2013, 04:25 PM
  3. Automated Vba Macro
    By Winon in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 10-03-2011, 05:15 AM
  4. macro for borders
    By mradam in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-04-2011, 10:41 PM
  5. [SOLVED] Borders - automated with page breaks
    By Mike W in forum Excel General
    Replies: 0
    Last Post: 04-11-2005, 06:06 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