View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jct
 
Posts: n/a
Default Event Macro - propogate formula

I am trying to use an event macro referenced in another thread,

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
Cancel = True 'Eliminate Edit status due to doubleclick
Target.Offset(1).EntireRow.Insert
Target.EntireRow.Copy target.Offset(1).EntireRow
Target.Offset(1).EntireRow.SpecialCells(xlConstant s).ClearContents
End Sub

(credit to: http://www.mvps.org/dmcritchie/excel/insrtrow.htm)

but am getting a debug message on the following line:
Target.Offset(1).EntireRow.SpecialCells(xlConstant s).ClearContents

I need clarification. Any help is appreciated.
Thanks,
Janice