HI


I have a query about looping with macros. I have uploaded a do-file of my code to this post. Essentially I am dealing with exchange rate data for 51 countries currently quoted relative to UK pounds and looking to convert to USD exchange rates by multiplying each country by the UK exchange rate. This is what I am looking for the loop to do. I have defined local macros for each country and a loop around these macros to achieve this. Unfortunately, whilst the code runs, the result is not correct for any of the countries other than the 1st (Argentina). I was wondering if anyone can spot a mistake in my code that can explain what is wrong?

Kind Regards

Sun Yong