I have a spreadsheet that contains currency name in col A e.g. USD, AUD etc. Col B contains the amount that needs to be converted into GBP. The calculations will happen in the VBA code below and results stored in col C, D and E</SPAN>
Sub SoSo()</SPAN></SPAN>
Dim Rng As Range</SPAN></SPAN>
Dim...