I'm trying to create an dynamic array of worksheets, place a commandbutton on each worksheet, write marco code via .Insertlines in a seperate CodeMolule to handle each commandbutton on each worksheet in the array.
All works well, until I .Insertlines and then I loose the reference (scope??) to the main array of worksheets.
So the created Marco doesn't work (no array)
Actual code can be posted...
Help again, guys
All works well, until I .Insertlines and then I loose the reference (scope??) to the main array of worksheets.
So the created Marco doesn't work (no array)
Actual code can be posted...
Help again, guys