Macro for filter
 

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

Macro for filter
 

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