On Mon, 19 Sep 2005 18:19:01 -0700, GarryKhoo
wrote:

Hi Ron,

Do you have sample code for VBA? Mind to share?



Sub foo()
Worksheets("Sheet2").Range("A1:A11").Copy _
(Worksheets("Sheet1").Range("A2"))
End Sub

will copy Sheet2!A1:A11 to Sheet2!A2:A12 -- contents and formatting and all.

But the specifics of how you implement something like this depends on the
details of your workbook.

You can also just record a macro, but the code gets more involved when you do
that.
--ron