Adjustment of Macro to include column added to invoicing template

**neil__g** · 11-29-2012, 07:06 AM

Morning,

Quite a few months ago I got some help from here with the following code -

Please Login or Register  to view this content.

This basically paste a blank invoicing line ready for filling in. It works great.

The problem is now I want to add an extra column to the invoicing and can't work out how to get it included within the macro.

Can anyone please help?

Thanks

**patel45** · 11-29-2012, 07:15 AM

Set TargetCell = Range("H1:L" & Cells(Rows.Count, "h").End(xlUp).Row).Find("row*", , xlValues, xlPart)

**neil__g** · 11-29-2012, 07:18 AM

Patel,

Thanks for the reply.

I have tried it but it doesn't work, the copied section actually runs from A - V (W with the extra column added)

**neil__g** · 11-29-2012, 07:24 AM

For Ease attached is a blank version of the form.

As you can see pressing the insert new row on invoicing adds a new row but doesn't add the newly inserted "fee remaining" column. Master Sheet.xlsm