for example i have 50 columns i filter the nulls in FBE.in filter by exp a parameter select_exp .what function is used .how to write the condition .i take a example on emp file(empno,ename,sal......).how to write the condition in filter by expression?

G

• Jan 13th, 2012

U can use : " " to filter null values using code.
Eg:
with worksheet.range("A1:B10")
.autofilter 2, criteria1: ""
end with

shiv

• Jan 2nd, 2012

IS NOTNULL(salary)

Answer Question  Select Best Answer