Thank you for your response.

It works for me. Where did you put the macro (what module)?
I paste in in
-In the Sheet1 worksheet.


What version of Excel are you using (I have 2002)?
-I am using 2003

What is your macro security setting (Tools - Macro - Macro Security)?
-Low