Hi All,
I have a table with a lot of formula and when I insert a new row it is always blank and doesn't carry the formula downward into the new row. I did some digging on Google and managed to find a work-around someone else had proposed which enters a new row (with all the formula) each time you double click within the table. This works very well and I will post the macro below. However... I have a need to double click into most rows when we enter data so this method isn't practical for us because every time I double click I get new rows, even if I don't necessarily need them! I really like the speed in which the double click works though so I wondered if anyone would be kind enough to tell me if we could have the same macro but double-click of the RIGHT cursor? This was general double clicking can be kept as usual but right double clicking would enter a new row? If not then any other suggestions welcome!
Thanks, here is the macro I was using:
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
'Updateby Extendoffice 20160725
Cancel = True
Target.Offset(1).EntireRow.Insert
Target.EntireRow.Copy Target.Offset(1).EntireRow
On Error Resume Next
Target.Offset(1).EntireRow.SpecialCells(xlConstants).ClearContents
End Sub
I have a table with a lot of formula and when I insert a new row it is always blank and doesn't carry the formula downward into the new row. I did some digging on Google and managed to find a work-around someone else had proposed which enters a new row (with all the formula) each time you double click within the table. This works very well and I will post the macro below. However... I have a need to double click into most rows when we enter data so this method isn't practical for us because every time I double click I get new rows, even if I don't necessarily need them! I really like the speed in which the double click works though so I wondered if anyone would be kind enough to tell me if we could have the same macro but double-click of the RIGHT cursor? This was general double clicking can be kept as usual but right double clicking would enter a new row? If not then any other suggestions welcome!
Thanks, here is the macro I was using:
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
'Updateby Extendoffice 20160725
Cancel = True
Target.Offset(1).EntireRow.Insert
Target.EntireRow.Copy Target.Offset(1).EntireRow
On Error Resume Next
Target.Offset(1).EntireRow.SpecialCells(xlConstants).ClearContents
End Sub