K wrote:
thanks lot smartin, man you are genious. The only thing I changed in
your macro was the file format which is "xlsm" and its working
superb. I been really looking forward for the answer as I am doing a
project and I needed this for that. Thanks again man


Good to know. Thanks for pointing out my typo (^: