Merge cells in added row.

[leaning]

Hello!

I have this code to add a row below a selected line. It also allows for separate formats of each cell.

I can't get the syntax right for merging the column A and B cells together. I remmed out the line I am having trouble with. Any help appreciated!

Lost

Please Login or Register  to view this content.

[Kelshaer]

you cant have Cells(c, 0).
the first column "A" is index 1
use the following code instead:

Please Login or Register  to view this content.

[leaning]

Kelshaer,

That wasn't exactly what I was looking for.

The user uses the attached file to review purchase paperwork. If there is a revision to paperwork already received, the user justs updates the bottom of the form with whatever changed in the revision. There could be no revisions or 200. So the user clicks a button to add a "revision row" and then there is also a delete button to delete rows.

Delete works fine. Add works fine, but many of the cells need to be merged. Any added rows need to look just like the example row.

I aprpeciate your help!

Lost

[Kelshaer]

please provide the paaswords to unprotect the sheet and view the vba code.
is it realy important for you to place the cursor on the last used cell in column A or can i modify the code to add the rows under the last cell??

[leaning]

Hello!

I ended up using Mr. McRitchie's InsertRowsAndFillFormulas macro. Works great. Sorry about not unprotecting the VBA. Thanks for your help!

(Updated file attached.)

Respectfully,

Lost