max and min values and change the currency

[htm]

need a VBA code that look for the max and min cost and change the currency to SAR

[jdelano]

The VBA code will greatly depend on the format of your sheet. Are these values always in the same cells or is a search required to find them on the sheet?

Do you have a cell that contains the conversion rate, or do you want code to pull this data from an online source?

[p45cal]

similar post:
https://chandoo.org/forum/threads/need-a-code-for-max-min-value-code.57290/