Understanding a macro

vilas desai
3StarLounger
Posts: 307
Joined: 16 Mar 2011, 09:33

Understanding a macro

Post by vilas desai »

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

User avatar
Rudi
gamma jay
Posts: 25455
Joined: 17 Mar 2010, 17:33
Location: Cape Town

Re: Understanding a macro

Post by Rudi »

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...
Regards,
Rudi

If your absence does not affect them, your presence didn't matter.