Storing flag values at worksheet level (Property or Properties
The set of worksheets to be copied is fixed. The user does not specify them.
I could use an array or other mechanism, but I'd prefer to simply set a
variable at the source. This would seem the more OO way to do things, and it
seems most compatible with my code as well.
"Bill Renaud" wrote:
Who and when do you decide which worksheets should be copied? Does the
user do this somehow before starting your macro, or does your macro
decide this internally somehow? If internally, then I guesss you would
simply put the flags into an array variable.
--
Regards,
Bill Renaud
|