Hi Nick,

OK then, where do I put the VBA code??? Im know Im probably getting to you
now, but I have never inputted VBA code into Excel. Also is there any
specific place the code should go???

OK, what we're doing is not a good way to start learning VBA. If we continue
down this path, you're going to get very confused very quickly. I strongly
suggest you stop what you're doing, go to your local bookstore (or
amazon.com), buy an introductory book about Excel VBA, read it and try the
examples. Once you've done that, you'll know where the code I gave you goes,
how to run it, how to stop it, etc <g.

Regards

Stephen Bullen
Microsoft MVP - Excel
www.oaltd.co.uk