You had a couple of replies to yesterday's post--one showed how to pass parms to
known macro name.

But if you don't even know the name of the macro, then how would you ever know
what to pass to them?


Jeff wrote:

Hi,

I have a lot of macros in my spreadsheet. And about 50% of the macros have
variables that are passed through them, so for example the macros look like
Macro1(x,y,z) rather then Macro1(). But usually to go to the code in a
macro I look up the macro in the list on the toolbar. Bur these macros don't
show up. Is there an easy way to go from one macro to the other's code. It
is getting to be a pain searching through the different "modules"

Thanks for your help

--

Dave Peterson