Hello everybody, please your help with the following macro coding:
Ranges:
Please see attached image.
Purpose:
Replace the styles in Workbook2 from macros in Workbook1.
Some definitions:
a) Range (J7:J13) in Workbook1 contains a list of the current styles in Workbook2.
b) Range (K7:K13) in Workbook1 contains the name of the new styles to apply in Workbook2.
c) Workbook1 contains the following macros: Normal1,BlueHeading,MainHeading, and Total2. These macros have the codes to modify the styles accordingly. For example BlueHeading macro makes the font blue, Normal1 makes font Calibri 11, and so on.
Code should:
a) Replace the current styles with the assigned target styles by running the corresponding macro and re-labeling the styles. For example Heading (current style in workbook2) should be replaced by MainHeading Style by running the macro with the same name that is in Workbook1.
b) Identify blanks in target style range and do nothing with the corresponding current styles. In present case Percent, Thousands, and Subtotal styles should remain as they are.
Please let me know if something is confusing.
Thanks in advance for your help!
Bookmarks