I have written macro code where the error is "Procdure is too long". I am manipulating a lot of mainframe data and charting it. The code ran until I got the "too long" error.

I have stored all the code in the "ThisWorkbook" so that the code is available to all sheets.

Should I move the code to "Module1"? "Module1" was created when I recorded a macro to determine needed code.

Can you have multiple "Modules"?

Is it desireable to have multiple "Modules"?

Would the move eliminate the "too long" error?

Would variables be available for all the sheets in the workbook?

Really confused after a long night of pushing code.

Craigm