Loop Counts Past # of Rows....WHY?

Hi,

I have worksheet2 filtered down, and I copied the filtered data over to worksheet1. Below is the loop for counting the number of days from the date in column D, and placing the number in column E. It is functioning correctly, but it continues to try and count past the data set in column D. It is actually taking the total number of rows from worksheet2 before it was filtered, and that is how far the loop is executing in column E.

Please assist me with the following question:

How do I make the loop stop at the end of column D in worksheet1?

Please Login or Register  to view this content.

Thank you,

Nick

Thank you for the quick responses. That worked, but I dont understand how that made a difference? What is the difference between the .cells and Cells?