show all/pivot - 2 questions


S

Steve

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?
 
Ad

Advertisements

J

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
formula...
 

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


Top