I've got it working a dream now! I had put 'worksheets' instead of
'worksheet' on the declaration line, Dim objSht As Excel.Worksheet. A
silly error to make. Thanks very much again for your assistance here.
:)


--
Blondegirl
------------------------------------------------------------------------
Blondegirl's Profile: http://www.excelforum.com/member.php...o&userid=29615
View this thread: http://www.excelforum.com/showthread...hreadid=532075