Thanks !. I have managed to sort this problem out by using If and End If. the
latest prob is trying to get a combo box to filter the data below 14%, it
looks as if it is trying to work but does not filter the data out.

"Rob Wills" wrote:

This should work on the latest value in the Combo box...

Just to be clear - at what point do you call the Macro?