i don't exactly understand the question, and i don't know if you can
autofilter based on comments............... maybe you need to start a
new thread asking this new question.
:)
susan, bowing out gracefully


On Jul 17, 10:40*am, Steve wrote:
Hey guys!

The code is working great. *I was wondering however, if it is possible to do
one last adjustment. *This one is going to be pretty tricky i think.

Currently if a formula is entered into the cell or copy and pasted into the
cell, the orange highlight goes away and so does all the stored information
about how made the overide. *Is it possible that if a formula is autofiltered
into a cell that it does the above too? *If not, it's no big deal of having
to copy and paste into the cell, but I was just curious.

Thanks so much!

Steve