Thanks Barb. Unfortunately I couldn't try your solution as I don't know much
about VBA and your codes requires to be adjusted with my original spreadsheet
names and settings. but I appreciate your care. and wish you the best in
reverse.