Hi stnkynts,

Thanks once again for the brilliant script.

Also, can you explain a little bit about the script and which value I have to modify it to work in various different worksheets? The script worked perfectly on the demo worksheet I provided on this thread but when I run the same script on the actual huge datasheet I have it throughs an error as : “Run-time error ‘9’: Subscript out of range”?

It would really be helpful if you explain a bit which fields I need to modify to get this magnificent script to work in different worksheet in the same scenario.

Thanks again mate. Cheers.