In addition...
The xlDown constant should also be qualified with the
ApplicationObjectVariable.
Jim Cone
"Jim Cone"
wrote in message...
Thanks,
wbExcel.Sheets(3).Rows("15").Copy
wbExcel.Sheets(3).Rows("15").Insert Shift:=xlDown
ApplicationObjectVariable.CutCopyMode = False ' adjust
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
"george" wrote in message...
How do I copy row 51 and insert that row above it.
Thanks