View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tushar Mehta Tushar Mehta is offline
external usenet poster
 
Posts: 1,071
Default Best Technique to clone worksheet

You need to use a class only if you use application level events. Of
course, it is a very good idea to do so. Start with XL VBA help for
'Using Events with the Application Object'

It is also a very good idea to separate the data from the code. I, for
one, don't distribute code in workbooks that will also contain data.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...

Cheers DM. I'll have a look into classes. (I'm not a novice programmer,
but I'm a relative novice to Excel so expect some more questions!)

Regards

Rich


--
Rich_z
------------------------------------------------------------------------
Rich_z's Profile:
http://www.excelforum.com/member.php...o&userid=24737
View this thread: http://www.excelforum.com/showthread...hreadid=384850