Learn AdvancedFilter Uses In VBAuuid:867403f4-8117-412e-a257-a50effaefdee;id=5682012-05-24T12:33:35Zuuid:867403f4-8117-412e-a257-a50effaefdee;id=5692012-05-24T12:33:35ZFilters or copies data from a list based on a criteria range. If the initial selection is a single cell, that cell's current region is used.<div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=btvF_8x87G8:Jgqf5fT43jM:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=btvF_8x87G8:Jgqf5fT43jM:V_sGLiPBpWU"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?i=btvF_8x87G8:Jgqf5fT43jM:V_sGLiPBpWU" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=btvF_8x87G8:Jgqf5fT43jM:qj6IDK7rITs"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?d=qj6IDK7rITs" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=btvF_8x87G8:Jgqf5fT43jM:gIN9vFwOqvQ"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?i=btvF_8x87G8:Jgqf5fT43jM:gIN9vFwOqvQ" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=btvF_8x87G8:Jgqf5fT43jM:7Q72WNTAKBA"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?d=7Q72WNTAKBA" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/SearchMsdn/~4/btvF_8x87G8" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/bb209640(v=office.12).aspxuuid:867403f4-8117-412e-a257-a50effaefdee;id=5702012-05-24T12:33:35ZFilters or copies data from a list based on a criteria range. If the initial selection is a single cell, that cell's current region is used. Variant.<div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=-18293Kk0Bo:5O07OatKFEc:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=-18293Kk0Bo:5O07OatKFEc:V_sGLiPBpWU"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?i=-18293Kk0Bo:5O07OatKFEc:V_sGLiPBpWU" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=-18293Kk0Bo:5O07OatKFEc:qj6IDK7rITs"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?d=qj6IDK7rITs" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=-18293Kk0Bo:5O07OatKFEc:gIN9vFwOqvQ"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?i=-18293Kk0Bo:5O07OatKFEc:gIN9vFwOqvQ" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=-18293Kk0Bo:5O07OatKFEc:7Q72WNTAKBA"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?d=7Q72WNTAKBA" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/SearchMsdn/~4/-18293Kk0Bo" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/aa221800(v=office.11).aspxuuid:867403f4-8117-412e-a257-a50effaefdee;id=5712012-05-24T12:33:35ZObject AdvancedFilter( XlFilterAction Action, Object CriteriaRange, Object CopyToRange, Object Unique )<div class="feedflare"> <a href="http://feeds.feedburner.com/~f/SearchMsdn?a=ANMjU4Su"><img src="http://feeds.feedburner.com/~f/SearchMsdn?d=41" border="0"></img></a> <a href="http://feeds.feedburner.com/~f/SearchMsdn?a=MKtI4pkV"><img src="http://feeds.feedburner.com/~f/SearchMsdn?i=MKtI4pkV" border="0"></img></a> <a href="http://feeds.feedburner.com/~f/SearchMsdn?a=s1mJsI8D"><img src="http://feeds.feedburner.com/~f/SearchMsdn?d=52" border="0"></img></a> <a href="http://feeds.feedburner.com/~f/SearchMsdn?a=CsHvsh3l"><img src="http://feeds.feedburner.com/~f/SearchMsdn?i=CsHvsh3l" border="0"></img></a> <a href="http://feeds.feedburner.com/~f/SearchMsdn?a=XWiqkfNh"><img src="http://feeds.feedburner.com/~f/SearchMsdn?d=50" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/SearchMsdn/~4/GAIu98YlufQ" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/microsoft.office.tools.excel.namedrange.advancedfilter.aspxuuid:867403f4-8117-412e-a257-a50effaefdee;id=5722012-05-24T12:33:35ZThe first example uses the AdvancedFilter method of the Range object and the second uses the Collection object. Sample code provided by: Dennis Wallentin, VSTO &amp; .NET ...<div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=B4kKpWJrzhM:QWuoX-UFkzY:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=B4kKpWJrzhM:QWuoX-UFkzY:V_sGLiPBpWU"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?i=B4kKpWJrzhM:QWuoX-UFkzY:V_sGLiPBpWU" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=B4kKpWJrzhM:QWuoX-UFkzY:qj6IDK7rITs"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?d=qj6IDK7rITs" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=B4kKpWJrzhM:QWuoX-UFkzY:gIN9vFwOqvQ"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?i=B4kKpWJrzhM:QWuoX-UFkzY:gIN9vFwOqvQ" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=B4kKpWJrzhM:QWuoX-UFkzY:7Q72WNTAKBA"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?d=7Q72WNTAKBA" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/SearchMsdn/~4/B4kKpWJrzhM" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/gg508925.aspxuuid:867403f4-8117-412e-a257-a50effaefdee;id=5732012-05-24T12:33:35ZThe following code example sets integer values in the range of cells from A1 through A5 and then uses the AdvancedFilter method to filter and copy the values to the ...<div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=II81WM-SSjc:iUKf1Pz-NqE:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=II81WM-SSjc:iUKf1Pz-NqE:V_sGLiPBpWU"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?i=II81WM-SSjc:iUKf1Pz-NqE:V_sGLiPBpWU" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=II81WM-SSjc:iUKf1Pz-NqE:qj6IDK7rITs"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?d=qj6IDK7rITs" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=II81WM-SSjc:iUKf1Pz-NqE:gIN9vFwOqvQ"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?i=II81WM-SSjc:iUKf1Pz-NqE:gIN9vFwOqvQ" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=II81WM-SSjc:iUKf1Pz-NqE:7Q72WNTAKBA"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?d=7Q72WNTAKBA" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/SearchMsdn/~4/II81WM-SSjc" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/microsoft.office.tools.excel.namedrange.advancedfilter(v=VS.80).aspxuuid:867403f4-8117-412e-a257-a50effaefdee;id=5742012-05-24T12:33:35ZFilters or copies data from a list based on a criteria range.<div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=9JemC9_e2JY:11-pouivq6M:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=9JemC9_e2JY:11-pouivq6M:V_sGLiPBpWU"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?i=9JemC9_e2JY:11-pouivq6M:V_sGLiPBpWU" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=9JemC9_e2JY:11-pouivq6M:qj6IDK7rITs"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?d=qj6IDK7rITs" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=9JemC9_e2JY:11-pouivq6M:gIN9vFwOqvQ"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?i=9JemC9_e2JY:11-pouivq6M:gIN9vFwOqvQ" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=9JemC9_e2JY:11-pouivq6M:7Q72WNTAKBA"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?d=7Q72WNTAKBA" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/SearchMsdn/~4/9JemC9_e2JY" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/microsoft.office.interop.excel.range.advancedfilter(v=Office.11).aspxuuid:867403f4-8117-412e-a257-a50effaefdee;id=5752012-05-24T12:33:35ZFilters or copies data from a list based on a criteria range. If the initial selection is a single cell, that cell's current region is used.<div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=ywp9v0n7T78:yOQqZ_rFzTg:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=ywp9v0n7T78:yOQqZ_rFzTg:V_sGLiPBpWU"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?i=ywp9v0n7T78:yOQqZ_rFzTg:V_sGLiPBpWU" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=ywp9v0n7T78:yOQqZ_rFzTg:qj6IDK7rITs"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?d=qj6IDK7rITs" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=ywp9v0n7T78:yOQqZ_rFzTg:gIN9vFwOqvQ"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?i=ywp9v0n7T78:yOQqZ_rFzTg:gIN9vFwOqvQ" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=ywp9v0n7T78:yOQqZ_rFzTg:7Q72WNTAKBA"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?d=7Q72WNTAKBA" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/SearchMsdn/~4/ywp9v0n7T78" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/ff841242.aspxuuid:867403f4-8117-412e-a257-a50effaefdee;id=5762012-05-24T12:33:35ZThis API supports the .NET Framework infrastructure and is not intended to be used directly from your code.<div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=_6dlVzLYFwE:5NAWECm_0-w:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=_6dlVzLYFwE:5NAWECm_0-w:V_sGLiPBpWU"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?i=_6dlVzLYFwE:5NAWECm_0-w:V_sGLiPBpWU" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=_6dlVzLYFwE:5NAWECm_0-w:qj6IDK7rITs"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?d=qj6IDK7rITs" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=_6dlVzLYFwE:5NAWECm_0-w:gIN9vFwOqvQ"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?i=_6dlVzLYFwE:5NAWECm_0-w:gIN9vFwOqvQ" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=_6dlVzLYFwE:5NAWECm_0-w:7Q72WNTAKBA"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?d=7Q72WNTAKBA" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/SearchMsdn/~4/_6dlVzLYFwE" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/microsoft.office.interop.excel.irange.advancedfilter.aspxuuid:867403f4-8117-412e-a257-a50effaefdee;id=5772012-05-24T12:33:35ZI'm having difficulty figuring out how the AdvancedFilter method works. I've been to http://msdn2.microsoft.com/en-us/library/bb209640.aspx and have a ...<div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=LC6aNGBzZxU:q0CCPI91vwk:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=LC6aNGBzZxU:q0CCPI91vwk:V_sGLiPBpWU"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?i=LC6aNGBzZxU:q0CCPI91vwk:V_sGLiPBpWU" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=LC6aNGBzZxU:q0CCPI91vwk:qj6IDK7rITs"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?d=qj6IDK7rITs" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=LC6aNGBzZxU:q0CCPI91vwk:gIN9vFwOqvQ"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?i=LC6aNGBzZxU:q0CCPI91vwk:gIN9vFwOqvQ" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=LC6aNGBzZxU:q0CCPI91vwk:7Q72WNTAKBA"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?d=7Q72WNTAKBA" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/SearchMsdn/~4/LC6aNGBzZxU" height="1" width="1"/>http://social.msdn.microsoft.com/forums/en-us/isvvba/thread/FF96C5E2-0DAB-42F1-8820-780A600FA36Buuid:867403f4-8117-412e-a257-a50effaefdee;id=5782012-05-24T12:33:35ZHi, I have been scratching my head on this one for a while... Excel 2007: I have one sheet with logdata (SCCM execmgr) of which one column contains "event ...<div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=hLSeKA-TOWs:jpVwt0mFg4A:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=hLSeKA-TOWs:jpVwt0mFg4A:V_sGLiPBpWU"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?i=hLSeKA-TOWs:jpVwt0mFg4A:V_sGLiPBpWU" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=hLSeKA-TOWs:jpVwt0mFg4A:qj6IDK7rITs"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?d=qj6IDK7rITs" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=hLSeKA-TOWs:jpVwt0mFg4A:gIN9vFwOqvQ"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?i=hLSeKA-TOWs:jpVwt0mFg4A:gIN9vFwOqvQ" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=hLSeKA-TOWs:jpVwt0mFg4A:7Q72WNTAKBA"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?d=7Q72WNTAKBA" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/SearchMsdn/~4/hLSeKA-TOWs" height="1" width="1"/>http://social.msdn.microsoft.com/forums/en-us/isvvba/thread/3F03B6FC-4569-48F9-8D54-425CCBD432ACuuid:867403f4-8117-412e-a257-a50effaefdee;id=5792012-05-24T12:33:35ZThe following example shows how to take a range of data in column A and delete duplicate entries. This example uses the AdvancedFilter method of the Range object with ...<div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=uXYxvAAZ7r0:T2KzYXCT7Fg:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=uXYxvAAZ7r0:T2KzYXCT7Fg:V_sGLiPBpWU"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?i=uXYxvAAZ7r0:T2KzYXCT7Fg:V_sGLiPBpWU" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=uXYxvAAZ7r0:T2KzYXCT7Fg:qj6IDK7rITs"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?d=qj6IDK7rITs" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=uXYxvAAZ7r0:T2KzYXCT7Fg:gIN9vFwOqvQ"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?i=uXYxvAAZ7r0:T2KzYXCT7Fg:gIN9vFwOqvQ" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=uXYxvAAZ7r0:T2KzYXCT7Fg:7Q72WNTAKBA"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?d=7Q72WNTAKBA" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/SearchMsdn/~4/uXYxvAAZ7r0" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/ff195120.aspxuuid:867403f4-8117-412e-a257-a50effaefdee;id=5802012-05-24T12:33:35ZHi, I'm having problems running an advanced filter on a worksheet created in Excel 2007. The problem is that if I attempt to generate the criteria using a ...<div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=gihUmA1MGSA:vlM53Yu52Yw:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=gihUmA1MGSA:vlM53Yu52Yw:V_sGLiPBpWU"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?i=gihUmA1MGSA:vlM53Yu52Yw:V_sGLiPBpWU" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=gihUmA1MGSA:vlM53Yu52Yw:qj6IDK7rITs"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?d=qj6IDK7rITs" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=gihUmA1MGSA:vlM53Yu52Yw:gIN9vFwOqvQ"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?i=gihUmA1MGSA:vlM53Yu52Yw:gIN9vFwOqvQ" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=gihUmA1MGSA:vlM53Yu52Yw:7Q72WNTAKBA"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?d=7Q72WNTAKBA" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/SearchMsdn/~4/gihUmA1MGSA" height="1" width="1"/>http://social.msdn.microsoft.com/Forums/en-US/exceldev/thread/ce129f9a-7c41-4bbf-87e6-a7afdef9547fuuid:867403f4-8117-412e-a257-a50effaefdee;id=5812012-05-24T12:33:35ZSee Also | AdvancedFilter Method | AutoFilter Method | AutoFilter Object | AutoFilterMode Property | FilterMode Property | ShowAllData Method<div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=3XjJS4WVpWY:4jRBaIX8roc:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=3XjJS4WVpWY:4jRBaIX8roc:V_sGLiPBpWU"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?i=3XjJS4WVpWY:4jRBaIX8roc:V_sGLiPBpWU" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=3XjJS4WVpWY:4jRBaIX8roc:qj6IDK7rITs"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?d=qj6IDK7rITs" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=3XjJS4WVpWY:4jRBaIX8roc:gIN9vFwOqvQ"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?i=3XjJS4WVpWY:4jRBaIX8roc:gIN9vFwOqvQ" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=3XjJS4WVpWY:4jRBaIX8roc:7Q72WNTAKBA"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?d=7Q72WNTAKBA" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/SearchMsdn/~4/3XjJS4WVpWY" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/aa221844(v=office.11).aspxuuid:867403f4-8117-412e-a257-a50effaefdee;id=5822012-05-24T12:33:35ZYou can use the ISNA and MATCH worksheet functions exclude records in an Excel database that do not match another list. To create exclusion criteria, use ...<div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=PhOGtJFudHY:mKPYiCqOaRw:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=PhOGtJFudHY:mKPYiCqOaRw:V_sGLiPBpWU"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?i=PhOGtJFudHY:mKPYiCqOaRw:V_sGLiPBpWU" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=PhOGtJFudHY:mKPYiCqOaRw:qj6IDK7rITs"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?d=qj6IDK7rITs" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=PhOGtJFudHY:mKPYiCqOaRw:gIN9vFwOqvQ"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?i=PhOGtJFudHY:mKPYiCqOaRw:gIN9vFwOqvQ" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=PhOGtJFudHY:mKPYiCqOaRw:7Q72WNTAKBA"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?d=7Q72WNTAKBA" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/SearchMsdn/~4/PhOGtJFudHY" height="1" width="1"/>http://support.microsoft.com/kb/183512uuid:867403f4-8117-412e-a257-a50effaefdee;id=5832012-05-24T12:33:35ZApplying a Filter to a PivotTable Field by Using the AdvancedFilter Method and C#; Applying a Manual Filter to a Pivot Field Using C#; Applying a Manual Inclusive Filter ...<div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=rd6fhQ2wjGw:ed5kC7UEPrk:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=rd6fhQ2wjGw:ed5kC7UEPrk:V_sGLiPBpWU"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?i=rd6fhQ2wjGw:ed5kC7UEPrk:V_sGLiPBpWU" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=rd6fhQ2wjGw:ed5kC7UEPrk:qj6IDK7rITs"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?d=qj6IDK7rITs" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=rd6fhQ2wjGw:ed5kC7UEPrk:gIN9vFwOqvQ"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?i=rd6fhQ2wjGw:ed5kC7UEPrk:gIN9vFwOqvQ" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=rd6fhQ2wjGw:ed5kC7UEPrk:7Q72WNTAKBA"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?d=7Q72WNTAKBA" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/SearchMsdn/~4/rd6fhQ2wjGw" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/ff536099(v=office.12).aspxuuid:867403f4-8117-412e-a257-a50effaefdee;id=5842012-05-24T12:33:35ZI see that the AdvancedSearchFilter class has several methods to filter read only date fields like AccountExpireDate and LastBadPasswordAttempt. I need to ...<div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=WPolYBB6Zlo:WEuZHRrm0RI:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=WPolYBB6Zlo:WEuZHRrm0RI:V_sGLiPBpWU"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?i=WPolYBB6Zlo:WEuZHRrm0RI:V_sGLiPBpWU" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=WPolYBB6Zlo:WEuZHRrm0RI:qj6IDK7rITs"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?d=qj6IDK7rITs" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=WPolYBB6Zlo:WEuZHRrm0RI:gIN9vFwOqvQ"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?i=WPolYBB6Zlo:WEuZHRrm0RI:gIN9vFwOqvQ" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=WPolYBB6Zlo:WEuZHRrm0RI:7Q72WNTAKBA"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?d=7Q72WNTAKBA" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/SearchMsdn/~4/WPolYBB6Zlo" height="1" width="1"/>http://social.msdn.microsoft.com/forums/en-US/netfxbcl/thread/d0938fae-795a-4bb0-a68b-7981a4f32c6auuid:867403f4-8117-412e-a257-a50effaefdee;id=5852012-05-24T12:33:35ZIn Microsoft Excel, when you use the Advanced Filter to filter a list on a worksheet, and the criteria range is located on another worksheet, the Criteria ...<div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=Jd7XvxVsquo:zg3fh3qVjSk:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=Jd7XvxVsquo:zg3fh3qVjSk:V_sGLiPBpWU"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?i=Jd7XvxVsquo:zg3fh3qVjSk:V_sGLiPBpWU" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=Jd7XvxVsquo:zg3fh3qVjSk:qj6IDK7rITs"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?d=qj6IDK7rITs" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=Jd7XvxVsquo:zg3fh3qVjSk:gIN9vFwOqvQ"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?i=Jd7XvxVsquo:zg3fh3qVjSk:gIN9vFwOqvQ" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=Jd7XvxVsquo:zg3fh3qVjSk:7Q72WNTAKBA"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?d=7Q72WNTAKBA" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/SearchMsdn/~4/Jd7XvxVsquo" height="1" width="1"/>http://support.microsoft.com/kb/115767uuid:867403f4-8117-412e-a257-a50effaefdee;id=5862012-05-24T12:33:35ZAdvancedFilter Method ... Pastes a Range from the Clipboard into the specified range. Syntax. expression ...<div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=L0mBaHkyKS0:S8sP-sOgcHA:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=L0mBaHkyKS0:S8sP-sOgcHA:V_sGLiPBpWU"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?i=L0mBaHkyKS0:S8sP-sOgcHA:V_sGLiPBpWU" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=L0mBaHkyKS0:S8sP-sOgcHA:qj6IDK7rITs"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?d=qj6IDK7rITs" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=L0mBaHkyKS0:S8sP-sOgcHA:gIN9vFwOqvQ"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?i=L0mBaHkyKS0:S8sP-sOgcHA:gIN9vFwOqvQ" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=L0mBaHkyKS0:S8sP-sOgcHA:7Q72WNTAKBA"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?d=7Q72WNTAKBA" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/SearchMsdn/~4/L0mBaHkyKS0" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/bb178854(v=office.12).aspxuuid:867403f4-8117-412e-a257-a50effaefdee;id=5872012-05-24T12:33:35ZWhat is the exception you get? I don't quite understand what "filter" do you mean. But i think at least you can read all data from one workbook and filter them in C# ...<div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=0CVJ2kxnEmc:EZyjc_rTSzg:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=0CVJ2kxnEmc:EZyjc_rTSzg:V_sGLiPBpWU"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?i=0CVJ2kxnEmc:EZyjc_rTSzg:V_sGLiPBpWU" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=0CVJ2kxnEmc:EZyjc_rTSzg:qj6IDK7rITs"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?d=qj6IDK7rITs" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=0CVJ2kxnEmc:EZyjc_rTSzg:gIN9vFwOqvQ"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?i=0CVJ2kxnEmc:EZyjc_rTSzg:gIN9vFwOqvQ" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=0CVJ2kxnEmc:EZyjc_rTSzg:7Q72WNTAKBA"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?d=7Q72WNTAKBA" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/SearchMsdn/~4/0CVJ2kxnEmc" height="1" width="1"/>http://stackoverflow.com/questions/8519948/c-sharp-and-excel-advanced-filteruuid:867403f4-8117-412e-a257-a50effaefdee;id=5882012-05-24T12:33:35Zrng2.Columns(FieldNum).AdvancedFilter _ Action:=xlFilterCopy, _ CopyToRange:=.Range("B1"), Unique ...<div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=odrcYyZFe74:AtczsfM3glg:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=odrcYyZFe74:AtczsfM3glg:V_sGLiPBpWU"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?i=odrcYyZFe74:AtczsfM3glg:V_sGLiPBpWU" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=odrcYyZFe74:AtczsfM3glg:qj6IDK7rITs"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?d=qj6IDK7rITs" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=odrcYyZFe74:AtczsfM3glg:gIN9vFwOqvQ"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?i=odrcYyZFe74:AtczsfM3glg:gIN9vFwOqvQ" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/SearchMsdn?a=odrcYyZFe74:AtczsfM3glg:7Q72WNTAKBA"><img src="http://feeds.feedburner.com/~ff/SearchMsdn?d=7Q72WNTAKBA" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/SearchMsdn/~4/odrcYyZFe74" height="1" width="1"/>http://social.msdn.microsoft.com/forums/en-US/isvvba/thread/64a1df78-2a10-4fb4-823c-04565867bb7d/