Results 1 to 8 of 8

Macro to insert formatted rows

Threaded View

  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.

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