bvm wrote:
In a multi-currency environment my staff keep mixing up currencies in
their spreadsheets e.g. subtracting costs in dollars from revenues in
Euros.

I would like to develop a macro that examines formulas in a spreadsheet
and looks for cells formatted in different currencies.

Some pointers on how to get started would be appreciated.
Thanks Bob that helped and by combining your suggestions with the
Precedent function I have been able to do exactly what I wanted as
stated originally.

I appreciate the sentiment in keepITcool - however if everyone drove
their cars properly there would not be any road accidents, but in the
real world....