Please explain what "broken" means.

Does the code run?
Does it produce error messages? If so, what do the messages say?
Does it produce unexpected/wrong results?
Does it hang?

Also, your profile says you use Excel 2003. Please update your profile to reflect what you are currently using.