View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone Jim Cone is offline
external usenet poster
 
Posts: 3,290
Default Insert Row Problem

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