Hi,
I have a macro which run perfectly from Excel but the file has to be posted on our company intranet which uses redirection so the file opens up inside Internet Explorer. I can't change user access to modify the settings to open an .xls file only in Excel either!
When the macro tries to run I get the infamous Run-time 1004 Method 'Range' of object'_Global' failed error which points to the code
cmbStoreList.Value = Range("B1").Value
all I can assume is that it can't find the range B1 but I don't know how to get around this.
The spreadsheet needs to work when being opened as it currently is, I've got no chance of changing company policy and I don't want the users saving a local copy and reopening the file (far too complicated for them!).
Any help really appreaciated!!!
I have a macro which run perfectly from Excel but the file has to be posted on our company intranet which uses redirection so the file opens up inside Internet Explorer. I can't change user access to modify the settings to open an .xls file only in Excel either!
When the macro tries to run I get the infamous Run-time 1004 Method 'Range' of object'_Global' failed error which points to the code
cmbStoreList.Value = Range("B1").Value
all I can assume is that it can't find the range B1 but I don't know how to get around this.
The spreadsheet needs to work when being opened as it currently is, I've got no chance of changing company policy and I don't want the users saving a local copy and reopening the file (far too complicated for them!).
Any help really appreaciated!!!
