Patrick wrote:
I am getting a runtime error on the format part of the code?
Any ideas?

I can't be sure with the information given.
What is the exact error message and on which line does it occur?

The code works fine for me - Excel 2003 & Windows XP.