edit worksheet activate vba to perform also when a cell is changed

[tlacloche]

good afternoon,

im currently using the following code to automatically filter out the N/A errors when i open the worksheet:

Please Login or Register  to view this content.

it works perfectly!!

however, i also want for the same thing to occur when the cell contents of either cells A1 or A2 is changed.
i dont know how to re-write the code to do this.

can someone please help.
thanks.

[Winon]

Hello tlacloche,

This may sound like a stupid question, but do you need the #N/A?

One could change the formulae not to show #N/A.

Regards

[tlacloche]

everything needs to remain as it is.
apologies if this complicates things but the whole worksheet works based on how it is currently set up.

i guess my question is fairly simple if you know how...How do you write a vba code to activate when a cell's contents is changed?

[scottlutes]

You can try something like this. I have not tested it, but it should get you on the right track.

Please Login or Register  to view this content.

[Izandol]

Perhaps:

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[tlacloche]

Izandol, youre a star!!!!!

[Izandol]

You are welcome.