| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to copy formula and paste into another
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula/ Macro that will copy and paste | Excel Worksheet Functions | |||
| I need formula help or create a macro to copy and paste value only | Excel Discussion (Misc queries) | |||
| Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
| Copy and Paste macro needs to paste to a changing cell reference | Excel Programming | |||
| Macro to Copy/Paste then Paste to Next Line | Excel Programming | |||
Threaded Mode
