autofilter question

[Lukums]

Hey guys,

Probably an easy one... but I can't work it out

I need for column 26 to be seen as blank: I thought the below would work but it doesn't.

.AutoFilter Field:=23, Criteria1:="Ridge300"
.AutoFilter Field:=25, Criteria1:="SEND THESE"
.AutoFilter Field:=26, Criteria1:=""

Any ideas for this to be seen only if criteria in column 26 is blank?

Thank you all.

Luke

 

[MARK858]

Try...

Criteria1:="[COLOR="#FF0000"]=[/COLOR]"

 

[Lukums]

Try...

Criteria1:="[COLOR=#FF0000]=[/COLOR]"

Omg...thank you so small so painful! THank you!