hi bill, have reduced the size of the spreadsheet by removing all
unnecessary formatting and the code now works without alterations. must
have been a bug somewhere but i always get annoyed when i dont get to
the solution.
but could be worse things on a monday morning eh!
thanks for your help.