Hi,

I suppose that 'Range("A1:R1").AutoFilter' doesn't recognize
the range of data correctly.
when the target range has no data, autofilter might fail.

release the filter, then try this:

ExlSheet.Range("A1").AutoFilter(Field:=1, Criteria1:= strSRNo,
VisibleDropdown:=False)

or

ExlSheet.Range("A1").CurrentRegion.AutoFilter(Fiel d:=1, Criteria1:=
strSRNo,
VisibleDropdown:=False)


--
HTH
okaizawa

Shalini wrote:
I want to perform the Autofilter programmatically using .Net but it is
not happening. Code, which I have written, is as under:

ExlSheet.Range("A1:R1").AutoFilter(Field:=1, Criteria1:="=" & strSRNo,
Visibledropdown:=False)

Please do the needful

Regards,
Shalini