DZone Snippets: worksheet code http://snippets.dzone.com/posts Fri, 25 Jul 2008 02:45:21 GMT DZone Snippets: worksheet code Detect a field edit in Excel and refresh a Query http://snippets.dzone.com/posts/show/3613 <code> <br />Private Sub Worksheet_Change(ByVal Target As Range) <br /> Dim wks As Worksheet <br /> Set wks = ActiveSheet <br /> <br /> If Target.Row = 1 And Target.Column = 1 Then <br /> wks.QueryTables(1).Refresh <br /> End If <br /> <br /> Set wks = Nothing <br />End Sub <br /></code> Fri, 02 Mar 2007 04:29:25 GMT http://snippets.dzone.com/posts/show/3613 davetrane (David Davis)