Hi All,

I would like to:

1) Find the LAST row of consecutive data (starts at column "A" - numeric
values in col "A", start row number varies)

2) Selct the FIRST to LAST cell of continuous data on that LAST row

3) Copy the FIRST to LAST cell of continuous data on that LAST row

4) Paste the copied data in the same cell position on the row immediately
below

If possible, can a solution be provided to do the above process on multiple
worksheets within the same workbook?

Thanks,
Sam

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200709/1