+ Reply to Thread
Results 1 to 8 of 8

Macro to insert formatted rows

  1. #1
    Registered User
    Join Date
    11-05-2007
    Posts
    32

    Macro to insert formatted rows

    Hello All,

    Can anyone tell me how I can get a macro to insert formatted cells into every other row in my spreadsheet (excluding the header row)? Getting it to insert an unformatted row is easy, but I need a merged cell and borders in order for it to be useful.

    I need columns A, B, and C to have borders all the way around each cell in the row. Then, columns D through H need to be merged, with one border around the merged cell. The row height needs to be size 16 font, which I've been solving by putting in one letter that size, colored white so it doesn't show up when I print.

    Basically, I have a spreadsheet of a bunch of tools, and I need to insert a row below each entry for the mechanics to sign their initials for three stages of the repair process, and also have the larger, merged cell for notes.

    Any help on this would be greatly appreciated.
    Last edited by oneblueaugust; 04-24-2009 at 05:03 PM. Reason: Solved.

  2. #2
    Registered User
    Join Date
    11-05-2007
    Posts
    32

    Re: Macro to insert formatted rows

    Just wondering if anyone's had a chance to look at this?

  3. #3
    Registered User
    Join Date
    11-05-2007
    Posts
    32

    Re: Macro to insert formatted rows

    Bump

    If I should take this to a different section of the forum, let me know.

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Macro to insert formatted rows

    As always, OBA, before-and-after examples are a lot more helpful than a description.
    Entia non sunt multiplicanda sine necessitate

  5. #5
    Registered User
    Join Date
    11-05-2007
    Posts
    32

    Re: Macro to insert formatted rows

    My bad. Please see attached.
    Attached Files Attached Files

  6. #6
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Macro to insert formatted rows

    Please Login or Register  to view this content.

  7. #7
    Registered User
    Join Date
    11-05-2007
    Posts
    32

    Re: Macro to insert formatted rows

    Works like a charm. Thanks a ton man, I really appreciate it.

  8. #8
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Macro to insert formatted rows

    You're welcome. And here I'd thought you'd died ...

+ Reply to Thread

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