Avatar of Andreas Hermle
Andreas Hermle
Flag for Germany

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
VBAMicrosoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
Roy Cox

8/22/2022 - Mon