PDA

View Full Version : Named Range issue using file online



debauch
09-11-2007, 12:47 PM
Hello,

We have a report that is posted to a website. On the report, there is a form where you can select criteria, then an advanced filter runs and copy's the filtered data to a new worksheet.

When used on our drive - it works fine. When users open the file through internet explorer, the following code errors out :


Range("RawDataRange").AdvancedFilter Action:=xlFilterCopy, _
CriteriaRange:=Range("FilterCriteria"), _
CopyToRange:=Sheet8.Range("A1"), Unique:=False

Any idea why this might happen? We tried hard coding the ranges in, however we would prefer it be dynamic since the data changes so often.