PDA

View Full Version : How to start from active cell



jeff06
06-27-2007, 12:47 PM
With ActiveSheet.QueryTables.Add(Connection:=connstring, Destination:=Range("A1"), Sql:=sqlstring)
.Refresh
End With

With this code, the query result will be written starting from cell "A1".

I want the query result to be written starting from the active cell I just clicked, How can I do that?

Thanks

Simon Lloyd
06-27-2007, 01:04 PM
How about

Destination:=Activecell

jeff06
06-27-2007, 01:28 PM
THX