Hi,

Thanks for your help, this works perfectly!
Just have a question about the Sh object is it possible to define the sheet you want to use eg Sheet("name") for this type of Change event?

Thanks