On Thu, 29 Jun 2006 09:18:15 -0500, halem2 wrote:

thanks. I'm getting en error pointing to invalid use of ME.

This code works fine if you put in into a worksheet module. If you want to
use it as a separate module, use ThisWorkbook.Sheets("sheetname") instead
of Me

--
PL