Jim - Many Thanks, and I'll be damned. I can't tell you how many times I
looked at the code and missed the mis-spell. Funny that the compiler error
was not that varinat was not defined.

I should have had a clue, 'cuz after I posted this, I removed all the
optional vars to split the function into two functions, and it worked.

Thanks agan.
--
Neal Z


"Jim Cone" wrote:

Neal,
It got a little tricky...

....Optional Opn2 As varinat = "") As Variant

should be As Variant = not As varinat =
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)


"Neal Zimm" wrote in message
Hi All,
I'm a little spooked. Getting a compiler error that uDrwRec is not defined
in the function statement.

The Public Type statement is as shown, in a module before the function.
I've moved it about..... no help. (I have not shown some variables to make
a shorter list here.)

Playing around, in the same function I typed: Dim TestRec as
and got the dropdown box showing uDrwRec and selected it.

In the next line I typed: TestRec. BUT DID NOT GET A VARIABLE LIST???

I'm building an Addin, error was not there yesterday, I use Rob Bovey's code
cleaner every day on the addin.

I'll be happy to supply any other info you might need.

Help !
Thanks, neal z.
-snip-