Macro to add a line containing indirect, change sheet names in formula

I need a macro that will add a line before the Utilities line in my Table of Contents. The new line will be a new Section line, so the formulas in the Description and Drawings columns will be the same, except the section number will change.

So in my test workbook, I will add a Section 4 worksheet, and then I want to click a button and have a line added in between section 3 and the Utilities line on my table of contents. In the description column, the formula will be "=IF(INDIRECT("'Section 4'!$F$3") = 0, " ", INDIRECT("'Section 4'!$F$3"))",
And the drawings column will have the same thing but F2 instead of F3.

Thank you to anyone who can help me here!

Can anyone point me in the right direction?

Please Login or Register  to view this content.

I edited some code I found to attempt it, but it's not great. Instead of referencing activecell.row, I want to insert the row before the Utilities line. I could always just set the active selection to the cell containing the string "Utilities" but I'm sure there's a better solution. This Macro copies the formula from the previous section, right? I need it to add 1 to the section # in the formulas, so probably using an i = i+1 kinda deal?

Why don't you just record the insert macro first, clean it up, and then post that? And then someone (not me, I can't write the stuff) can help you write the formula change macro. You've been posting a lot of these, so I figure that these are all going to be kind of connected, right? Well you can always just record a lot of micro-macros (hehe ) and then right a macro to call all of them at once.

Oh. That doesn't work, now does it? You can try, but your 'Utilities' line will be changing so you need a reference based on those contents. I have a thread posted trying to get an answer for that, hopefully one of us can get an answer for you.