MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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


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

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