View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.programming
Harold Good Harold Good is offline
external usenet poster
 
Posts: 81
Default I'm new to VBA - why more than one Module?

These comments are all showing me I'd better learn how to do a better
job of it, lest others have to clean up my code down the road.

Thanks again for all your help,
Harold

Bernd P wrote:
Hello,

One small addition:

If you need to clean up somebody else's code and if that guy had not
used OPTION EXPLICIT (happens, unfortunately), you might want to
create a new module starting with OPTION EXPLICIT. Then you clean up
function by function and sub by sub: delete it from the old module and
create it in the new one.

Regards,
Bernd