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:

[TABLE="width: 500"]
<tbody>[TR]
[TD]Data[/TD]
[/TR]
[TR]
[TD]Unique[/TD]
[/TR]
[TR]
[TD]Duplicate[/TD]
[/TR]
[TR]
[TD],[/TD]
[/TR]
</tbody>[/TABLE]

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 ??