Excel AutoFilter using ASp.net
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 |
Excel AutoFilter using ASp.net
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 |
Excel AutoFilter using ASp.net
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 |
All times are GMT +1. The time now is 06:48 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com