Hello MD,

Well that is clear enough. Thank you again.

Regards,

Carpiem
Quote Originally Posted by mdmackillop
Hi Carpiem,
A named range would work fine. The only reason for the range is to exclude cells where you would not wish the code to run. eg, titles, totals or whatever. You could also get the code to run only if the text contains the / character. It's all depends on your conversions.
Regards
MD