When I run the macro i made nothing happens and works fine. I sent to a coworker and he keeps getting:

Run Time Error '9':
Subscript out of range

I cant figure out why it would work for me and not him

HTML Code: 
HTML Code: 
HTML Code: