Is gosub the answer

[rhino4eva]

i have three macros contained in a single worksheet
1= a validation macro
2= a printout macro
3= a save macro

i want to be able to validate then print as well as validate and save
the easy wasy is to copy the validate macro and paste it in front of each of the other 2 macros. But that seems messy and duplicates code. I feel i should be using a gosub at the start osf 2 and 3 but i am not sure how to implement it. anyone got any ideas ???

 

[VoG]

In 2 and 3

Call Validate ' use the actual name of 1

 

[Norie]

GoSub wouldn't work if you want to call code in a separate sub.

You should probably avoid it anyway.

There are various ways you could approach this.

For example you could have code at the end of the validation that calls either the print macro or the save macro, or both.

 

[rhino4eva]

thanks VoG

just to clarify the macro is called CheckNUM

so i need a line in the start of 2 and 3

Call CheckNUM

which will run CheckNUM and then run the code in 2 or 3

 

[VoG]

thanks VoG

just to clarify the macro is called CheckNUM

so i need a line in the start of 2 and 3

Call CheckNUM

which will run CheckNUM and then run the code in 2 or 3

Yes, exactly.

 

[rhino4eva]

Thank you for such a speedy reply