Andreas Hermle
asked on
Enter a certain term in the header rows of smart tables using VBA
Dear Experts:
I got hundreds of smart tables spread over a lot of worksheets.
I would like to run a macro on all of these smart tables with the following requirements:
Loop thru all smart tables in all worksheets with the exception of worksheets named 'base_sheet' and 'final_sheet'.
Enter the term 'Quantities per one set' in the third column (ie. e.g. C2 or C 23 or C 84) of all header rows, overwriting the cell contents. All of the smart tables have header rows.
Help is much appreciated. Thank you very much in advance.
Regards, Andreas
I got hundreds of smart tables spread over a lot of worksheets.
I would like to run a macro on all of these smart tables with the following requirements:
Loop thru all smart tables in all worksheets with the exception of worksheets named 'base_sheet' and 'final_sheet'.
Enter the term 'Quantities per one set' in the third column (ie. e.g. C2 or C 23 or C 84) of all header rows, overwriting the cell contents. All of the smart tables have header rows.
Help is much appreciated. Thank you very much in advance.
Regards, Andreas
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Pleased to help
ASKER
Regards, Andreas