VBA Filters with multiple conditions/criterias

[prsnthkrishna]

Hi, I have an excel file. In S Column, I need to select only #N/A. In A column, I need to deselect number 990 and I need to deselect the Text values.

Can anyone help in this using VBA?

 

[Marc L]

Hi,​

​

no need any VBA procedure just using some Excel basics like a filter, at kid level …​

If really a code is necessary just activate the Macro Recorder then operate manually : you will get your own code !​

​

 

[prsnthkrishna]

In the attached excel file, there are one 3 texts.. it is an example. I have more than 20-30 texts.. recording macro doesn't work for my main file..

And, thanks for ur suggestion..

 

[Marc L]

In the attached excel file, there are one 3 texts.

What this means ?!​

​

Before to start the Macro Recorder just do it manually using a filter for example​

(needing around 10 seconds as one column requires a single criteria and another column just two).​

Once you get the easy logic and the result is what you expect for​

then you can restart the same operations with the Macro Recorder.​

recording macro doesn't work for my main file..

So it seems you must first repair your Excel as when the Macro Recorder can't work so VBA either …​

​