What is the maximum number of lines for code?

[decklun]

Hi All,

Does anyone know if there is a limit to the number of lines you can have in a macro? And if so, does it vary for modules and user form code?

Thank you!
decklun

 

[Richard Schollar]

Hi Decklun

Check out the following link:

http://www.dailydoseofexcel.com/archives/2004/10/13/module-size-limits/#comments

 

[decklun]

Thanks Richard! Enjoy your weekend!