Joel / Peter T / Steve,

Many thanks for your generous input.

Sorry for the delay in replying, been a bit busy !

If l have got this right then my attempt to amend the function to a
'stand alone' (ie not incorporate into the string function) function
into which l can pass the MyWB & MySh variable only needed to have Is
Nothing replacied with Is Missing.

Is this correct?

If so it more efficient to have both the 'varaible' & 'string'
versions available within a workbook and use whichever is appropriate
or use Peter's combined version?

Peter - I didn't realise it was so complex to combine the 2 but it
will be very useful.

Steve - In answer to your question the Function(LRs.........etc) that
l posted will return the last row of whichever column you enter ie "A"
"Z" etc but if you leave that parameter blank it will return the last
row on the worksheet whatever column it is in. I have not tried it on
range!

Regards

Michael