I have built an Excel model which performs various convoluted calculations based on dropdown boxes and text box input.
One element takes the product of values from 2 text boxes and divides this by an exchange rate, which is selected via a dropdown box. The various exchange rates are held in the background on the spreadsheet itself, in the cells immediately below a named-range cell called "ExRate".
When run as a standalone in Excel, this all works fine. However, a colleague has been trying to run the model over an intranet through Internet Explorer. Everything works fine except for this one reference to a named range. It keeps throwing up the dreaded
"1004 method "Range" of object "_Global" failed"
Here's the line of code that the debug jumps to:
Txt_OrderFOB£.Value = FormatCurrency((Txt_FOB.Value * Txt_BuyQty.Value) / Range("ExRate").Offset(Cbox_Currency.ListIndex, 0).Value, 2)
I'm not sure why this is happening specifically through IE. Is some part of Excel's ability to refer to itself lost when run this way?
Any help greatly appreciated.
Regards
wadjssd
One element takes the product of values from 2 text boxes and divides this by an exchange rate, which is selected via a dropdown box. The various exchange rates are held in the background on the spreadsheet itself, in the cells immediately below a named-range cell called "ExRate".
When run as a standalone in Excel, this all works fine. However, a colleague has been trying to run the model over an intranet through Internet Explorer. Everything works fine except for this one reference to a named range. It keeps throwing up the dreaded
"1004 method "Range" of object "_Global" failed"
Here's the line of code that the debug jumps to:
Txt_OrderFOB£.Value = FormatCurrency((Txt_FOB.Value * Txt_BuyQty.Value) / Range("ExRate").Offset(Cbox_Currency.ListIndex, 0).Value, 2)
I'm not sure why this is happening specifically through IE. Is some part of Excel's ability to refer to itself lost when run this way?
Any help greatly appreciated.
Regards
wadjssd