Hi DM,

Unfortunately this will be called from several worksheets which
obviously will have different names and slightly different layouts,
but all with the same set of properties.

It's actually working now with the declaration 'AS OBJECT' and as there
will not be any dynamic calls to the function, i can be certain that
the sheets using the function will always have the correct properties.

Thanks for your input!

regards

Rich


--
Rich_z
------------------------------------------------------------------------
Rich_z's Profile: http://www.excelforum.com/member.php...o&userid=24737
View this thread: http://www.excelforum.com/showthread...hreadid=383054