Always have at least 1 blank row in table

[birpal]

I want to always have a blank row in my table that has the same format and formulas from the rows above is that possible?

[JBeaucaire]

1) Highlight your current table
2) Press CTRL+T to activate the Table function.

Now if you start typing anywhere in the blank row below your table it will instantly expand to include your new row, formatting , formulas and all.

[raman1667]

Hi Birpal,

PFA and PFB for the small macro. Paste this code in sheet module which contains the table. In this code, i have used "Sheet1" as sheet name and "table1" as table name, you can change the sheet name and table name as per your requirement. This worksheet change event will run only when you change the value of any cell in the last row of the table. I hope this code will help.

Please Login or Register  to view this content.

Regards
Ramandeep Singh
Please Click * icon to Add Reputation if my answer helped!

[raman1667]

Hi Birpal,

You get the answer to your question. If you are satisfied with the answer, kindly mark this thread as SOLVED.

If my answer helped, kindly add reputation by clicking on the small "star" icon located in the lower left corner of the post.

Regards
Ramandeep Singh
Please Click * icon to Add Reputation if my answer helped!