Fun: Longest Macro

[Gerald Higgins]

Thanks Rorya and Greg. I'm guessing I won't be allowed to download Greg's link, but I can use the text file solution easily enough. It turns out I have some that are much larger than 64k, I probably should clean them up !

 

[Andy Pope]

Here is a sinlge liner I posted on DDoE.
http://www.dailydoseofexcel.com/archives/2004/10/13/module-size-limits/

Enter this in the Immediate pane, making sure the code module is active.

?len(application.VBE.ActiveCodePane.CodeModule.Lines(1,application.VBE.ActiveCodePane.CodeModule.CountOfLines))/1000