Norman

Right, I forgot the OE when I copied to an add-in in its own module.

Gord

On Sun, 5 Dec 2004 02:57:50 -0000, "Norman Jones"
wrote:

Hi Gord,

Correct on the ileft/cleft issue, although it seems to make no difference
when
the code runs??

Only if no Option Explicit statement is used. Personally, I would always
advocate the use of OE.

I prefer Bob's code ...

I too like Bob's code, especially his adroit use of a dialog sheet. My use
of Jim Rech's code is driven by habit and a penchant for using inbuilt
functionality if possible.

---
Regards,
Norman



"Gord Dibben" <gorddibbATshawDOTca wrote in message
.. .
Correct on the ileft/cleft issue, although it seems to make no difference
when
the code runs??

I prefer Bob's code as the worksheets are listed on one visible "page"
with
option buttons rather than a scrollable listbox.

Gord