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?

Kativa,

You would likely have to monitor a change in event of that cell to determine
the course of action.
--
http://www.ExcelHelp.us

888-MY-ETHER ext. 01781474



"kativa" wrote:

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?

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:

Kativa,

You would likely have to monitor a change in event of that cell to determine
the course of action.
--
http://www.ExcelHelp.us

888-MY-ETHER ext. 01781474



"kativa" wrote:

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?