Is this right? what am i missing? it does not seem to work. I'm usin
Office system 2003

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$C$3" Then
With QueryTables("myQueryTable")
.Connection
"URL;http://table.finance.yahoo.com/d?a=...&g=d&s=)" & _
CStr(Range("C3").Value) & "&d=t"
.Refresh False
End With
End If
End Su

--
Message posted from http://www.ExcelForum.com