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.

As always, OBA, before-and-after examples are a lot more helpful than a description.

Please Login or Register  to view this content.

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