If you'd like to send me the workbook, I can take a look at it. Remove
the capital letters from my posted email address, to get the real address.

PFL wrote:
I used the info from your website to construct the dynamic range. The
range includes all cells I expected. Originally It did not due to data
in row 2000. I checked the formats of the data by Format=Cell= Date.
The dynamic range only has 10 rows of data at present



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html