Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-19-2012, 12:37 PM
56_kruiser 56_kruiser is offline Range Name in Adv Filter -> NOt working Windows 7 64bit Range Name in Adv Filter -> NOt working Office 2010 64bit
Novice
Range Name in Adv Filter -> NOt working
 
Join Date: Nov 2012
Posts: 26
56_kruiser is on a distinguished road
Default Range Name in Adv Filter -> NOt working


Is it not possible to specify the range for the advanced filter via a Named Range? I have tried it when the range was a table, and when it was not. In both cases, I did not get an error, but it filtered out everything except the first row, which did not meet the criteria of the filter.
Reply With Quote
  #2  
Old 11-20-2012, 12:45 AM
Kevin@Radstock Kevin@Radstock is offline Range Name in Adv Filter -> NOt working Windows 7 32bit Range Name in Adv Filter -> NOt working Office 2010 32bit
Office 365
 
Join Date: Feb 2012
Posts: 94
Kevin@Radstock is on a distinguished road
Default

Hi 56_kruiser

Not that I am aware of, try here:

http://office.microsoft.com/en-gb/ex...005200178.aspx
Reply With Quote
  #3  
Old 11-20-2012, 09:58 AM
56_kruiser 56_kruiser is offline Range Name in Adv Filter -> NOt working Windows 7 64bit Range Name in Adv Filter -> NOt working Office 2010 64bit
Novice
Range Name in Adv Filter -> NOt working
 
Join Date: Nov 2012
Posts: 26
56_kruiser is on a distinguished road
Default

Well, I just have been having a brain fart. I just went in and tried again, and it works with range names, both for specifying the range, and the criteria.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Apply filter with VBA bobsawyer7 Outlook 0 03-12-2012 04:02 AM
Range Name in Adv Filter -> NOt working filter kwlickt Excel 1 03-28-2011 11:15 AM
Range Name in Adv Filter -> NOt working Select a range in one one workbook while working in other workbook Slow&Steady Excel 1 02-21-2010 03:34 AM
Range Name in Adv Filter -> NOt working could you help me help me with advanced filter Nora Excel 1 05-15-2009 11:10 AM
junk email filter not working michmurp Outlook 0 09-15-2008 10:57 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:57 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft