Thank you all very much for the detailed information. It is exactly what i
wanted and needed. too bad i could only say that one answer was correct.

Also, is there any advantage to using Worksheets over Sheets to refer to
Worksheets? either performance, code legibility, experience, etc?

Currently i am using Sheets and referring only to worksheets.

-rogge