adding rows with macros without ruining other macro references

[mltornroth]

Wondering if someone can help me. I've scoured message boards and excel/vba sites but I'm not getting anywhere fast. I would like to add code to the 'Add Row' buttons so that, if pressed, a blank row will be added to the section below it corresponds with. The buttons are placed alongside the titles of the section they should add the row to. Problem I am having is that once I add a row to one section, something off sets that functionality when the button is pressed for one of the sections below it. The code should unprotect and reprotect the worksheet at the start and finish and there is text hidden in the protected columns to the right of it that I'm using to adjust the row height of merged cells. So those formulas would have to be carried down as well. Can anyone help with this? (password is blank)

thanks in advance


oh yeah, and the macro that fits text for the rows in those sections is also not aligning when rows are added so if that can be fixed as well that would be great.help adding rows.xlshelp adding rows.xls

[Richard Buttrey]

Hi,

See attached.

I've simplified your macros and put the 'add row' macros in a new module called 'AddRow'


Regards

[mltornroth]

oh my lord I think I love you Richard. I honestly can't thank you enough. I really appreciate you taking the time to reply and work on that for me. It makes such a huge difference. It works perfectly. Seriously thank you so much.