It's like hitting the END key on the keyboard.

The code says to go to .range("a" & rows.count)
which is the same as
..range("a65536") (the bottom cell in column A)

So if you were doing it manually, you'd go to A65536, hit the End key and
finally the up arrow key (xlup in code).

It finds the last use cell in that column (A).


kpriyac wrote:

what does the end do in the following statement -

Set Rng = .Range("A1", .Range("A" & Rows.Count).End(xlUp))

--
kpriyac
------------------------------------------------------------------------
kpriyac's Profile: http://www.excelforum.com/member.php...o&userid=37535
View this thread: http://www.excelforum.com/showthread...hreadid=573077

--

Dave Peterson