Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
moving the formula "average" over one column in a macro | Excel Worksheet Functions | |||
Help on Macro or Formula | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Fill Formula - Macro | Excel Discussion (Misc queries) | |||
Can you enter a formula in a cell to run a macro? | Excel Worksheet Functions |