John Garabiles John Garabiles - 1 year ago 80
SQL Question

Excel VBA - how to display the SQL results on a specific cell?

With ActiveSheet.QueryTables.Add(Connection:.., Destination:=Range("A1"))

so instead the sql results will display starting in A1, i would like to specify it depending on what the value inside the cell B1 for example

i tried this:

With ActiveSheet.QueryTables.Add(Connection:..,Destination:=Range("A1").value)

but its not working.

Answer Source

That's because Range("A1").value is returning a String containing "B1" instead of a Range object representing the B1 position.

Try this instead: ActiveSheet.QueryTables.Add(Connection:..,Destination:=Range(Range("A1").value))

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download