Call Sub on Different Worksheet

[grnzbra]

I have two Worksheets, Equipment and Reference. On the reference sheet, I have a sub which I need to call from the equipment sheet. I keep getting a message saying the sub doesn't exist. I tried creating a public sub in a module which then tries to call the sub on the reference sheet. When I call that sub from the equipment sheet, it goes to the module and then gives me the error saying that the sub (the on on the reference sheet) doesn't exist. How can I call the reference sub from the equipment sub?

 

[SkipVought]

Hi,

VBA question are best addressed in forum707.

"I have a sub which I need to call from the equipment sheet"

WHY? Do you really have code in your sheet module and not in a standard module? If so, why?

Please explain exactly where this code resides and also when you repost in forum707, please post the code in question.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]