show all/pivot - 2 questions



1. Is there a way to programically go through the worksheets and show all
rows where a filter is applied? I don't want to remove the autofilter. I
have a macro that needs all rows to show in every worksheet. I don't know
whether there is a filter applied on any given worksheet.

2. If I'm doing a vlookup and the thing I'm looking up is a blank cell, my
formula returns a zero. Short of doing an if(lookup=0,"",lookup), is there a
way to return a blank?



Jim Thomlinson

Tools -> Options -> View and uncheck Zero Values. This will keep all zeros
from showing up on this sheet. Otherwise you are stuck with the ugly

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads