Change ws designator
Thanks...in the future if I want this macro to run on all of the worksheets
in the workbook what would I need to change?
"JE McGimpsey" wrote:
One way:
Change
Set rDest = .Parent.Sheets("Sheet2").Cells( _
.Rows.Count, 1).End(xlUp).Offset(1, 0)
to
Set rDest = .Parent.Sheets("Sheet2").Cells(12, 1)
In article ,
Jerry Foley wrote:
Thanks much...it works great. One last question...How can I specify for the
rows being copied to sheet2 to start at row 12 of sheet2.
|