Hi Vasant,

Thanks for your help.

What if in stead of selecting this:

Range("N2").Copy Range("N3:N" & LastRow)

I want to randomly select any cells in row 2 to CopyToEnd, how can I
use the Selection in ActiveSheet to do this job ?

Thanks in advance for help.


---
Message posted from http://www.ExcelForum.com/