Forum Discussion
Debug macro for importing and graphing currency prices
Hi All,
I am looking to import prices into excel via a userform and then graph the historical prices. I am found some useful code and hints and on the net, however I am still experiencing run errors when run the macro.
Any assistance in how to debug the process would be greatly appreciated.
kind regards,
Callum
1 Reply
In Excel, press Alt+F11 to open the VBA Editor, then press F8 to run the code line by line. Check the data range and chart data source, and make sure the exchange rate is in number format. If errors persist, add `On Error Resume Next` at the beginning and `On Error GoTo 0` at the end of the code.
