Get autofilter to exclude blank cells that contain formulas

[bobert1980]

I have the following line in a macro:

Range("b22:L" & Range("J" & Rows.Count).End(xlUp).Row).AutoFilter

This selects rows based on whether they contain data and creates an autofilter of the range.

The data Im using this on will have blank cells as the bottom rows but they will contain formulas that blank the cells based on ISNA() conditions,

How do I get the above code to only select cells with visible data and ignore those that are blank but contain formulas.

thanks

 

[bobert1980]

There are definitely no formulas in column B.

WHen I use the CountA function ir returns the right number of rows for B

Can I incorporate worksheetfunction.CoountA into this code to get it to work?

thanks