Hi all,

I have an formated row for data, but I do not know the exact row row number
since the data amount is variable, so I make only one ready for copy and
insert after. I use the Record produced code like following:

Worksheets("printout").Rows(row + iItemStart & ":" & row + iItemStart).Select
Selection.Copy
Selection.Insert Shift:=xlDown
Application.CutCopyMode = False

but before I can use the code, I have to make the printout sheet the
activesheet, do I have other method?

Clara
--
thank you so much for your help