Posted by Michael on November 03, 2001 6:09 AM
Hi, I have never written VBA untill today, so bear with me. I have a cell pulling in live data via a stock quote. I need to copy the value in real time to another cell to get the previous quote. My problem is the Worksheet_Change/Copy Range thing I am doing doesn't work sinve it sees the "on update" cell as unchanged since it has the formula to get the live quote. What can I do to copy the value instead of the formula every time the value changes?
Here is what I have:
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
Dim VRange As Range
Set VRange = Range("Bid")
If Union(Target, VRange).Address = VRange.Address Then
Thanks for ANY help!!