Visual Basic - Procedure Too Large (Compile Error)

[omairhe]

Sub MacroOmair()
'
' MacroOmair Macro
'

'My code here
End Sub

procedure too large ... someone could give a solution to this error...im a newbie in vba

 

[xld]

Break it down into separate procedures in more than one module.

 

[omairhe]

oki it gives 3 options.... UserForm, Module and Class Module when 2nd click on module in vba.

i click on module?
and then how will i start and end and execute them together later on. thanks for the reply

 

[omairhe]

anyone??

 

[omairhe]

got my answer here....

creating regurlar module.. name it different and call it

www.automateexcel.com/2004/08/14/excel_vba_run_a_macro_from_a_macro