Hi,

@Pecoflyer, yeah sorry I didn't know I had to wrap the code. I will do that next time.

@No Sparks, thanks for your reply. Yes my code is located in Book.xlsx.

I haven't tried your code yet but I will let you know if it works as soon as I try and run it.

Also, just a quick question. I'm new to VBA and want to know when to use the "With" command.