that would not (easily) happen in a well designed sheet.

make sure that different currencies end up in different columns.
Or:

have 1 column for "values" and a separate column as a currency selector.
(3rd column ofcourse the calculated value in "reporting currency"

never rely on numberformatting... (what if they paste values?)




--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


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.