On Fri, 16 Mar 2007 06:49:59 -0700, "Doug Glancy"
wrote:

Kirk,

Can you show us the code and describe what's happening. Or for yourself,
can you create a simpler test case and still duplicate the behavior?

Doug

Hi Doug,

I'd be happy for you to take a look but a mass analysis by the group
would be too embarrassing! My coding is very much done on the fly and
this is my first big thing in Excel VBA. For expediency I've kept to
syntax's and commands I was already familiar with. I suspect there's
many things done quite differently and the whole thing would horrify a
real programmer.

But it does intrigue me why what should be set in concrete, fails.
Apart from the no-initialise problem there was one line that simply
didn't work - sometimes. Couldn't believe it when I stepped
through... anyway the 'fix' has been to call the initialise prodedure
again from List1.Enter. This seems to have solved the problem.

It's quite large now and to break it down to islolate a particular
issue would be some work. Also whatever's wrong isn't constant
- you can duplicate the same thing 15 times before it faults.
That was the worst bit - trying to see it fault to figure out what was
wrong! Anway with this change I'll hammmer it for a few days and
see what happens.

Cheers - Kirk