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

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

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

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

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