passing a variable to a procedure

[Matthew Leggett]

Can some1 remind me how I pass a variable from one procedure to another in excel visual basic

[Dalek Dave]

without seeing the code or knowing the context, it is difficult to give a good answer, but I would suggest that you throw out the variable to a FUNCTION.

Function FunctionName(Prefix As String) As String

Do something here to generate/define/call the variable

End Function

You can call the fuction from the other module Hope that helps

------------------------------------ "I want you to imagine I have a blaster in my hand" - Zaphod Beeblebrox. "You DO have a blaster in your hand" - Freighter Pilot "Yeah, so you don't have to tax your imagination too hard" - Zaphod Beeblebrox