Auto copy comment on new cells of dynamic table?

[renguer0]

Hi there. I have a dynamic table named Tabla, with two columns named A and B and I want to every cells on that columns (new ones that can be added with TAB key increasing table size) have the same comment.

In the screenshot that i've attached, you'll see the first row commented (with LIMIT text inside) but when I expand the dynamic table, the comment is not copied to the new rows of the table.


English is not my native language but I try to explain as best as I can do. Thanks for your time.

 

[Sam_D_Ben]

I guess instead of dragging, Please try Copy, then right click - Paste Special. This should work.

 

[Sam_D_Ben]

Oh you posted this question before.

https://www.mrexcel.com/forum/excel...matically-all-cells-column-dynamic-table.html

Are you looking to automate it. Well in that case, thank you.

 

[renguer0]

Oh you posted this question before.

https://www.mrexcel.com/forum/excel...matically-all-cells-column-dynamic-table.html

Are you looking to automate it. Well in that case, thank you.

Yep, I'm looking for some VBA code or something else I guess.

Thanks.