Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
show all/pivot - 2 questions
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... -- HTH... Jim Thomlinson "Steve" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
show data dependant on certain columns (2 dif questions) | Excel Worksheet Functions | |||
Pivot Table Questions | Excel Discussion (Misc queries) | |||
Pivot Tables-2 questions | Excel Discussion (Misc queries) | |||
Pivot Tables-2 Questions | Excel Worksheet Functions | |||
pivot table questions | Excel Worksheet Functions |