Macro for filter

[comotoman]

Sheet 1: b7:b37 can be filled with a blank at any time(depends on the date) Is there a macro that can make filter not show any blanks when updated?(not show empty rows)

[Robert Mulroney]

like this?

public sub filterBlanks()
Range("B7").Select
Selection.AutoFilter Field:=1, Criteria1:="<>"
end sub


- Rm

"comotoman" wrote:

>
> Sheet 1: b7:b37 can be filled with a blank at any time(depends on the
> date) Is there a macro that can make filter not show any blanks when
> updated?(not show empty rows)
>
>
> --
> comotoman
> ------------------------------------------------------------------------
> comotoman's Profile: http://www.excelforum.com/member.php...o&userid=27292
> View this thread: http://www.excelforum.com/showthread...hreadid=473890
>
>