Autoheight + buffer space for select rows

I found a few related topics, but none that were exactly what I needed--largely because I've worked a lot with spreadsheets, but have no experience with how macros work, so I don't know how to go about using most of the answers that were given.

I have a spreadsheet that I need some way to add some buffer space to the bottom of a certain selection of rows, 5px or so. I'm not even sure what my options are for whether this would happen automatically or where to put the code or anything, so any and all help would be fantastic.

I'm really glad so many people like helping out us newbs for fun! I really appreciate you guys!

Um, it's not specific for this spreadsheet, so I don't think there's a need for me to upload anything. It could be done for any spreadsheet--I just need rows # through # to be adjusted to autoheight + 5px. They're just regular old text, no formulas or adjusted size or length of rows or anything. Is there specific information more than that that you'd need?

I don't know exactly what to do with this. I'm pretty new to any kind of excel coding. Could you be so kind as to help me out with where this needs to go? =)

Mike,

First, thanks so much for your help so far.

I've got the macro working, but unfortunately it shrinks the rows to a really small size. Is there a way to adjust it to the proper autoheight, and then add another 5px to that?

Thank you again!

PS--Will this work for merged cells and cells with line breaks/more than one line?

Great, almost there. I just have two more questions.

1. How can I make this work on lines that have word wrapping?

2. Is there a simple way to make this check whether a row has already had the height adjusted so that when I run the macro more than once, it doesn't just keep adding 5px to the row height?

Again, thank you so much. There are a lot of little tweaks I didn't realize I'd have until I was tinkering with it.

The text wraps in the merged columns C-G. What code would I need to use to do the autofit/re-add bit?

*bump* I know it's been a while, but can anyone help me finish this so I can close it?

Thanks!