Mike - thanks - very logical and obvious when its pointed out to you. This
will obviously work with calc set to auto - I am set to manual to increase
speed (lots of calcs) - I will need to think it through and may have to
compromise the man/auto or scrap what I was trying to do - in any event,
thanks for the help


--
Roger


"Roger" wrote:

Does anyone know of an event that will run as soon as the user has used the
autofilter please



--
Roger