View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
bstobart bstobart is offline
external usenet poster
 
Posts: 16
Default 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