MyRange = Worksheets("Sheet1").Cells(Rows.Count, _
1).End(xlUp).Row

Abdul Salam
-----Original Message-----

Hi all

Is it possible to "select" a varying amount of text for
copying from a worksheet (sheet1) that will never be the
same range? I need excel to !find" the extent of the
range
for copying every time?

Part of the macro I run copies text from "sheet"1
to "sheet 2", but the number of rows is always
different
in sheet 1

Is this possible using VBA?

Thanks for your help.

Regards,

Michael

.