Simon Lloyd;418648 Wrote:
Trixie, apart from a whole load of code that could go and some that can
be tidied there's nothing wrong with it, there may be some code in your
PERSONAL.xls which is causing this error, to find it it may be in one of
these locations c:\program files\microsoft office\office10\excel\xlstart
OR
c:\program files\microsoft office\office\excel11\xlstart, take a look
at the VBE and see if there is any code in there at all.

On the subject of tidying up, there was a lengthy piece of code, which
was a macro I recorded that basically hides every 6th row (starting at
row 9 and continuing through row 903 when a click command is entered.
Is there a cleaner way to do this than the way the macro records it?

If needed, I can copy here.

Thanks!


--
Trixie

~TRIXIE
------------------------------------------------------------------------
Trixie's Profile: http://www.thecodecage.com/forumz/member.php?userid=438
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=116018