VBA for deselecting filter selection

[tonyjyoo]

Hello,

I need a VBA that opens the filter dropdown in a column, deselects ",".

Thank you,

Tony

 

[Michael M]

Can you provide more information ??

 

[tonyjyoo]

Can you provide more information ??

For example, lets say in Column A (Data) I have:

Data

Unique

Duplicate

,

<tbody>
</tbody>

I need a VBA that selects the drop down filter menu for Column "Data", deselects ",", and then deletes the rest.

 

[tonyjyoo]

Basically want to avoid deleting blank rows that have formulas in them.

 

[Michael M]

So you simply want to delete all blank rows in Col "A", except those that contain a formula ??