| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide show blanks
Hi
I have an Excel sheet that has the AUTO FILTER ON I would like a macro that will hide all the blanks in a col when that col is selected Would appreciate any help Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Hide show blanks
This will select all non-blanks in Column A: Columns("A:A").Select Selection.AutoFilter Selection.AutoFilter Field:=1, Criteria1:="<" "PCOR" wrote: Hi I have an Excel sheet that has the AUTO FILTER ON I would like a macro that will hide all the blanks in a col when that col is selected Would appreciate any help Thanks |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Hide show blanks
Thanks...but....can you give me a macro that will show all non blanks and
"any selected column" Thanks "Toppers" wrote in message ... This will select all non-blanks in Column A: Columns("A:A").Select Selection.AutoFilter Selection.AutoFilter Field:=1, Criteria1:="<" "PCOR" wrote: Hi I have an Excel sheet that has the AUTO FILTER ON I would like a macro that will hide all the blanks in a col when that col is selected Would appreciate any help Thanks |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Hide show blanks
Possibly:
Selection.EntireColumn.AutoFilter Field:=1, Criteria1:="<" -- Regards, Tom Ogilvy "PCOR" wrote in message ... Thanks...but....can you give me a macro that will show all non blanks and "any selected column" Thanks "Toppers" wrote in message ... This will select all non-blanks in Column A: Columns("A:A").Select Selection.AutoFilter Selection.AutoFilter Field:=1, Criteria1:="<" "PCOR" wrote: Hi I have an Excel sheet that has the AUTO FILTER ON I would like a macro that will hide all the blanks in a col when that col is selected Would appreciate any help Thanks |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Hide show blanks
Worked great...thanks
"Tom Ogilvy" wrote in message ... Possibly: Selection.EntireColumn.AutoFilter Field:=1, Criteria1:="<" -- Regards, Tom Ogilvy "PCOR" wrote in message ... Thanks...but....can you give me a macro that will show all non blanks and "any selected column" Thanks "Toppers" wrote in message ... This will select all non-blanks in Column A: Columns("A:A").Select Selection.AutoFilter Selection.AutoFilter Field:=1, Criteria1:="<" "PCOR" wrote: Hi I have an Excel sheet that has the AUTO FILTER ON I would like a macro that will hide all the blanks in a col when that col is selected Would appreciate any help Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Chart Blanks Out When I hide data column | Excel Discussion (Misc queries) | |||
| Auto update a list and don't show blanks | Excel Worksheet Functions | |||
| How to hide blank rows after data whilst leaving some blanks. | New Users to Excel | |||
| Show Non Blanks using MS Query | Excel Discussion (Misc queries) | |||
| Show value 0 in blanks fields | Excel Programming | |||
Linear Mode
