Dear Experts,
I am enclosing four workbooks each with a tiny macro (Module - placed in the sheets called "Data"). To my understanding the macro copies the template from the worksheet "AIWITHJB" and inserts values from the sheet "Data" into as many number of sheets as there are (number of Rows - 1) in the sheet "Data"
Is my understanding correct? Except for the macro in the Module "Generate Drawings" click button, does the work book have any more macros?
(The workbooks are sent to Hans and Rudi on their emails since the zipped file size was larger than 250KB)
Please advise
Best regards
Vilas Desai
Understanding a macro
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Re: Understanding a macro
AFAIK, you are correct in your analysis.
The macro loops through as many entries as is in column A of the appropriate workbook and generates a copy of the AIWITHJB sheet, then names it.
Each workbook only contains one macro...the one that loops through the column A from Data...
The macro loops through as many entries as is in column A of the appropriate workbook and generates a copy of the AIWITHJB sheet, then names it.
Each workbook only contains one macro...the one that loops through the column A from Data...
Regards,
Rudi
If your absence does not affect them, your presence didn't matter.
Rudi
If your absence does not affect them, your presence didn't matter.