I see your point (now!).

Jim Cone wrote:

Hi Dave,
But you could have code in one workbook operating on another workbook and
Ken, in his original post, specifies a particular workbook.
However,he doesn't say where the code is located.
See my second post.
--
Jim Cone
Portland, Oregon USA
(xl2007 is a downgrade)

"Dave Peterson"
wrote in message
Although I think it's always a good idea to qualify the ranges (including
.rows.count), I don't think it's the problem in this case.
Each worksheet in the workbook will have the same number of rows--
either 64k or 1M rows--depending on how it was saved and reopened.
(The number of rows between worksheets in the same workbook won't vary.)

--

Dave Peterson