Archive of Mr Excel Message Board


Back to Data in Excel archive index
Back to archive home

AutoFilter

Posted by Scott on December 12, 2000 11:52 AM
I'm trying to referance a number I get after I filter
out all the number I don't want. My problem is once I use the filter command
my formula gets all screwed up. How do I get the right cell after the filter?

Thanks


Re: AutoFilter

Posted by marbel on December 12, 2000 3:22 PM

How about paste special/value the range before filtering it?
mb


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.