I want to perform the Autofilter programmatically using .Net but it i
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,
Shalin

--
ShaliniPosted from http://www.pcreview.co.uk/ newsgroup acces

Try it without the brackets:

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

You also probably don't need the = sign:

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

Hope this helps
Rowan
"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


--
ShaliniPosted from http://www.pcreview.co.uk/ newsgroup access

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