Hello -
I am currently trying to develop a macro button that will convert all currency in a workbook to a different foreign currency and back simply.
In my example, I will be trying to change from USD to British Pounds. The model spans multiple worksheets and has numbers formatted as "Accounting" & "Currency". My current script is below, however it only changes numbers formatted as 'Currency' and not numbers formatted as 'Accounting'. Does anyone know what I am doing wrong?
Any help would be greatly appreciated.
Bookmarks