Sounds curious!

Could you explain, or if it's complicated I'd also be interested to see your
workbook.

Regards,
Peter T
pmbthornton gmail com


"Kris_Wright_77" wrote in message
...
Tom very kindly looked at the spreadsheet for me.

Unfortunately, he identified a strange interaction between the code for
formatting and the UDF.
Both pieces of VBA run perfectly provided that the other is "switched
off",
and unfortunately this cannot be achieved by adding code to conditionally
exit either the Formatting or UDF.

Tom provided a work around which involves making the workbook calculate
manually, but is not an ideal solution.

Should anyone have any experience of similar problems, I would love to
know.

Kris
<snip