End(xlUp) simply looks for the end cell, looking up the column relative to
where the start point is. That start point can be a specific cell (B1000),
or more dynamic (Cells(Rows.Count,"B"))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"m4nd4li4" wrote in message
ups.com...
Hello,

Please could someone explain how End(xlUp) works?? I have also seen
End(xlUp) (2) as well, again I have no idea what it means. I have
searched this group and the various sites but I could not get any
satisfactory answers.

Regards,

Bharesh