Cheers Dave, I think you've picked it out.

I do a lot, and I mean a massive amount, of inserting/deleting rows in
both the Change History worksheet and all the other worksheets. I
thought it was something to do with that as you could sort of match up
how the hyperlinks were out of order.

I may look at using the function you list next time.

Thanks again


--
StuB
------------------------------------------------------------------------
StuB's Profile: http://www.excelforum.com/member.php...o&userid=29174
View this thread: http://www.excelforum.com/showthread...hreadid=489038