Quote:
Originally Posted by MYGS
Yes 'on blinking' would be good... LOL 
The column doesn't get updated when you change a cell, only when you do the double-click + ENTER process, I don't know anyone who does this, do you? |
I don't know anyone who does this, except maybe, you...
Most of the people i know, between double click and enter, is typing data, or writing formulas...
Another idea for you is to run your macro every 30 seconds, or less ...
Sub CopyFormulaResults()
Application.OnTime Now + TimeValue("00:00:10"), "CopyFormulaResults"
Range("H10:H50").Select
Selection.Copy
Range("I10").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
Application.CutCopyMode = False
End Sub