Macro to insert new row at the end of a table

[FredFitzgerald]

Hi Guys

Any help with this will be much appreciated. I've created a table, however I want to control it as much as possible with the features below:

1. I want a macro to insert a new row if users want to add a new line of data.
2. I want the formulas in the greyed cells to be copied down when a new row is inserted, example is the last row in the table.
3. I want the greyed cells only to be protected with a password


Many thanks

[kersplash]

1. If you convert your "table" into a real table (Insert->Table), you simply start entering data below the first row and it becomes part of the table.
2. If it's a table the formulas automatically expand to the new row.
3. Protection is tricky when tables are involved - I'll pass on this one.

[xladept]

Hi Fred,

I put this code in a module:

Please Login or Register  to view this content.

And assigned it to your rectangle

Here's the now macro-enabled book:

[FredFitzgerald]

Awesome xladept. Thank you very much. Please can you amend the script to copy down the formula in column A as well.

Muchas gracias !!!

[xladept]

Hi Fred,

Here's an amendment:

Please Login or Register  to view this content.

De Nada - you're welcome and thanks for the rep!

[FredFitzgerald]

Hi xladept, I tried to protect the cells which have the formula and the macro couldn't run successfully- is there a reason why its so?

[xladept]

Well, the program writes in those cells - so, if they're protected the program can't run.

Try not protecting the column A formulas since they're entered by the program.