Hi DInesh,

That macro is perfect! Everything looks great. I have another question, can I use this macro in a shared worksheet? I've tried to run the macro in a shared workbook but it doesn't do anything.