Well Said, Mr. Hobs. And Thank you once again for responding in a timely manner. The code given by you just nails it. It works perfectly on the sample report.

But when I try to modify it and run on the actual report, it's another story.

Actual Report.xlsm

I know I should have provided you this earlier. It contained sensitive data that's why I didn't do it in the first place. My sincere apologies.