On Thu, 24 Nov 2011 11:41:42 -0500, Ron Rosenfeld wrote:

One of the problems with using UsedRange to find the last row is that if the last row has previously been cleared, it may still show up in UsedRange unless UsedRange has been reset. So I use UsedRange as a starting point, but not as the final determinant.

It may be that accessing UsedRange in VBA always resets it properly, according to some brief Googling without extensive testing.
So that objection of mine may be moot. If that is the case, then the previous, shorter routines would be better.