Autofilter Refresh Code

[RhyGuy]

Hi All,

I have a worksheet that has an autofilter to display non-blank cells. These cells are formula based, which rely on other worksheets for the result. The result in each cell can fluctuate to from blank to non-blank depending on the variable i am looking up at that time. Example is: Rows 10-20 are formula based cells. Cell B2 is an input cell where I input my region. Whichever region is in B2 will dictate the data populated in rows 10-20. Depending on the region being searched, sometimes a cell is blank, while other times it is populated.

So what I am looking to do is have a code that will update the autofilter results to display only the non-blank cells.

If there are any suggestions I would really appreciate the help.

[Richard Schollar]

How is autofilter being applied to the sheet? Do you want the results to appear on the current sheet or copied to another (presentation) sheet? If you have a sample workbook, it would certainly help (remove any confidential data first) to attach it in a reply.

Richard