Thank you Paul, much appreciated. Not that I understand it at this my stage of VBA knowledge. I'm also of the belief it is better to be explicit and avoid misunderstandings. I have learned from past mistakes that future memory is uncertain so it's best to plan for the future in the present. With your implied permission I will store your code with that intent.

The whole point of the code was to avoid the Div/0 error message I was getting by copying the empty currency cells which were parts of the formula and the conditional formatting. In the end, by scrabbling around on google searches I have changed the formulas to an IFERROR solution =IFERROR(G27/F27,0), in the copying process,; hence deleting that long line of code altogether. So, problem solved.

Again, if there is an alternative or "better'" way I will be interested to learn about it.

Regards,
Ron S