Thank you for your comments and I have reviewed the rules.

I have changed my title and thank you FDibbins for marking my codes with the tags.

Abousetta - I made the changes as you suggested, but still receiving error 1004 - Method "Range of object_Global" failed.

I will do some research on this and keep you posted if I am able to resolve this.

If there are any other suggestions, I will welcome it.

Thank you.