hello

i am not able to achive auto filter. i am pasting the code below

private void FilterReport()
{
string bookPath = @"D:\Window Crawler\Test Data
\PatchMatrix.xls";
Excel.Workbook _repbook = OpenExcelWorkbook(bookPath);
Excel.Worksheet _shtrep = (Excel.Worksheet)
_repbook.ActiveSheet;

//_shtrep.AutoFilterMode = true;
_shtrep.EnableAutoFilter = true;

Excel.Range Rngrep = _shtrep.get_Range("E1",
Type.Missing);
Rngrep.Select();
Rngrep.AutoFilter(1, "<",
Excel.XlAutoFilterOperator.xlAnd,Type.Missing,fals e);
}

it gives error : AutoFilter method of Range class failed

kindly help

Thanks
Shantanu