How to: If autofilter is "all" then, else...

[kativa]

I want to change a value in a cell when autofilter criteria is "all" and if
it isn't then go on to another code. How to do that with ifelse?

 

[galimi]

Kativa,

You would likely have to monitor a change in event of that cell to determine
the course of action.

 

[kativa]

I'm sorry, I didn't quite understand your answer... I thought this would be
quite simple (for the ones who can write the code in the right way). I
thought the way to solve my problem would be something like this:

if autofilter.selection is "all" then
range("A5").delete
else
worksheet("Taul1").Select... and so on and so on
end if


"galimi" kirjoitti: