Help organizing large program

[Andrew]

Hello,
I have a VBA program, which is written all on sheet1 of a workbook. I
have about 15 subroutines and it is getting hard to navigate around
the code. I'd like to move some of the completed subs off of sheet1
and maybe put them into modules. I'd especially like to move all of
the variable declarations onto another page. I have about 100
variable, all are global with respect to sheet1. I have tried this,
but I can't get the variables to transfer over. Please advise.

1. How do I create global variables which would be visible from all
sheets and all modules?
2. How do I take a subroutine out of sheet1 and into a module?

thanks for your help

 

[ryguy7272]

Use a Public Sub! Look at this
http://www.your-save-time-and-improve-quality-technologies-online-resource.com/vba-private-sub.html

HTH,
Ryan---