View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dean Goodmen Dean Goodmen is offline
external usenet poster
 
Posts: 18
Default Copy/Insert Rows Help needed

I have having trouble with the following lines....

Here is what I want it to do : Copy the Row contained in value cRow,
and insert a copy of it just below that row. (Only the Formaulas AND
Borders, not the vlaues of the cells.)

With Worksheets(1)
.Rows(cRow + 1).Insert xlShiftDown
.Rows(cRow).Copy
.Rows(cRow + 1).PasteSpeciaxlPasteFormulasAndNumberFormats
End With