How to filter the null records in filter by expression?

For example i have 50 columns i filter the nulls 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?

Questions by madhu922.m   answers by madhu922.m

Showing Answers 1 - 3 of 3 Answers


  • Dec 28th, 2011

You can use NOT ISNULL(empid).

  Was this answer useful?  Yes


  • Jan 2nd, 2012

IS NOTNULL(salary)

  Was this answer useful?  Yes


  • Jan 13th, 2012

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

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions