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


--
Craigm
------------------------------------------------------------------------
Craigm's Profile: http://www.excelforum.com/member.php...o&userid=24381
View this thread: http://www.excelforum.com/showthread...hreadid=382754