Quote:
Originally Posted by macropod
You could use a simple copy/paste to replicate the entire cell's contents. However, that still doesn't address the automation issue or the problems associated with addong/deleting rows.
Of course, if the second table is supposed to replicate the first one entirely, simply bookmark the first one and use a cross-reference for the second table.
|
Unless I am missing something, when you select a cell within a table and use the copy/paste function it only pastes the related text not the background format. I find this strange. Also if you use bookmarks it only references the text of the cell none of the shading.
As for the automation, if you notice I use a variable for a counter to check the number of rows in a table. If rows are added or deleted it will be reflected in that count and when the total is reached the program ends.
I am receptive to improvements if anyone has one.
Thanks1