Jim, I have set a breakpoint and until now I had not put in a msgBox.
I just put int eh MsgBox and it fired just like it is suppoed to. It
still skips all of the other steps that I ahve asked the macro to
perform. When stepping through, it goes through line by line, but not
of the tasks are performed. any thoughts?

Thanks,
Jay