Hi Steven,

5. I have found a few examples on the web showing progress bars but
I can't seem to figure out how to increment the progress bar while
it runs through my macro.

The progress bar obviously is on a userform, so you need to show the
form too.

Before your loops start, add:

ProgressBar.Show vbModeless

Then when done, don't forget to hide and destroy the form:

ProgressBar.Hide
Unload ProgressBar

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com