Hi Macker72,
It's hard to say why this is happening without seeing your code. Also, when you say it "crashes", what do you mean? Does it crash Excel, or does the macro just get a fatal error. If the latter, what is the error message, and what is the line of code it errors on?
Damon