Hi,

I have a sheet with about 48 rows and columns with data from Row A to
Row CD. When The macro runs I want to create a new sheet and copy the
first 5 rows to the new sheet and give the user a way to choose the
other row to copy to the new sheet.

I am able to create the new sheet and to let the user select the rows
to copy, buth the new sheet is blank. Could Somebody please help.

Thx
dpatwary