Macro to copy formula and paste into another
That worked as well! Amazing how many different approaches can result in the
same outcome! Thanks to you all from USMC in Iraq.
"Jacob Skaria" wrote:
n = Target.Row
With Target
.Value = Excel.Range("D" & n).Formula
End With
Cancel = True
If this post helps click Yes
---------------
Jacob Skaria
"usmc-r70" wrote:
I found and successfully loaded the following code, but I must use the ENTER
key for it to be fully posted.
Any idea?
Private Sub Worksheet_BeforeDoubleclick(ByVal Target As Range, Cancel As
Boolean)
n = Target.Row
With Target
.Value = Excel.Range("D" & n).Formula
End With
SendKeys "{ENTER}", True
End Sub
|