I have a sub Format_MySweetSheet to autofit rows and every nth column (n = 3) which works fine. It is the last sub called by the main macro. My quandary is why Format_MySweetSheet doesn't appear to run when it is called by the main macro.
The main macro in Module0 calls Sub1, Sub2, and Sub3.
Sub1 is in Module1 and calls Sub1a, Sub1b, Sub1c
Sub2 is in Module2 and calls Sub2a, Sub2b, Sub2c
Sub3 is in Module3 and calls Sub3a, Sub3b, Sub3c, Sub3d, Sub3e, and Format_MySweetSheet
Everything is in one workbook.
- Sub3e works with the same sheet as Format_MySweetSheet, and ends by selecting cell A1 of that sheet.
- After I run the main macro, Sub1a through Sub3e have all run, yet the column widths and row heights have not been adjusted.
- When I run Format_MySweetSheet separately and immediately after, the columns and rows are adjusted as desired.
Any ideas, please?
The code for the autofit sub is:
Many thanks!
Bookmarks