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.

Now that you do know, could you please add them in your first post ?
Thanks

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Hey,



Thanks so much, the code worked brilliantly. Also I hate to ask but how do I edit my original post to include code formatting?


I appreciate your help and the tips.