Bob Phillips Wrote:

What I could do is to put the table and the results on the same page,
in
separate windows, and the user could then close the second window if
they
didn't want it, or it is a small table. The teams table would be
separate
though still.

As for the VBA version, you don't know the sequence of events that
caused by
any chance, I would like to fix it.



Thanks again or the further post, Bob. Sounds good to me- would it
possible to print the two separate windows as one page of hardcopy ?

As a very basic workaround on the VBA version I'd simply added a few
'=' operators to the right of the fixture grid that linked to the
relevant cells in the table worksheet. This then gave me the table on
the same worksheet as the fixture grid.

I'm afraid I don't know the exact sequence but I think it was a
combination of adding the table to the fixture worksheet and
adding/deleting teams that caused the run-time errors. Perhaps I was
putting the table in a place where the fixtures overlapped ? Sorry I
can't be more sure than that.

Cheers
Garry


--
gdh82
------------------------------------------------------------------------
gdh82's Profile: http://www.excelforum.com/member.php...o&userid=35902
View this thread: http://www.excelforum.com/showthread...hreadid=557213