View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JohnH JohnH is offline
external usenet poster
 
Posts: 27
Default Link Macros Excel 2007

I recorded a macro (very large copy from one sheet and paste into another
sheet). It works fine. I then made some edits to it so that it would be more
generic abd reusable. This caused it to be to big to compile so I have to
slice it up into multiple marros.Both still work fine. How do I link the
maros so after macro1 finishes, marcor2 will start or is that just going to
introduce the file size problem again?

Do comments count in compield file size? I extensively commented the maro so
I could find my way around when debugging.

Thanks - John