Danno,

Danno wrote:
Thank you for the reply. I am not sure what I am doing wrong. Keep
getting exictuable errors.

In my example, I used Sheet1 as the worksheet object. You should change
this to Sheets("<yoursheetname") - other than that, it should work. Can
you post your code and indicate the line that raises the error along with
the error # and description?

--
Regards,

Jake Marx
www.longhead.com


[please keep replies in the newsgroup - email address unmonitored]