I've been working on a fairly big project for several weeks. So far it has
18 Sub modules and a few Procedures. Today I created a new Sub (called
SortRsltWorkArea), which just happens to have four arguments.

When I attempted to test the macro, I was unable to initiate it via either
F5 or F8. F8 just gives me a "ding" sound (as does "step into" via the Debug
menu). F5 (or the equivalent from the Run menu) presents me with the window
that shows all the macros for this project in alpha order. SortRsltWorkArea
is not listed.

It DOES exist however; it shows up as Module18 in the Project-VBAProejct
window.

I subsequently created a sub (TestSort) that successfully calls
SortRsltWorkArea, and if I Step Into (F8) TestSort it steps through
SortRsltWorkArea too.

I'm assuming that I accidentally set something in SortRsltWorkArea that is
causing this behavior, but I'm not having any success figuring out what that
something is.

I've tried copying the code from SortRsltWorkArea into a different (new) sub
and deleting the original version, with no success. I also tried changing
the name.

I'm running Excel 2007 - but since I haven't had this problem with any of
the other subs I've created for this project, that doesn't seem likely to be
significant.

Any ideas?? It's not a big deal now - I'll remember that it's there.
However, when I (or, worse yet, someone else) needs to do maintenance on this
thing a year or more from now, I suspect this is likely to cause trouble.
--
Kay