Help with QueryTable and using the ActiveCell

[Lowgrey]

I'm calling in data from a webpage, but I need the "Destination:=Range" to be the active cell on the spreadsheet. I tried every combination of "Destination:=ActiveCell" that I could think of, and the Query just doesn't like it.

Any ideas? Here's the copy of the code below. The "Destination:=Range("G1")" needs to accept the current active cell on the spreadsheet, or it needs to be a variable pointing to the cell.


With ActiveSheet.QueryTables.Add(Connection:= _
"URL;http://www.xxx.com/sti_counters.html", Destination:=Range("G1") _
)

Thanks!

 

[markyc]

hey, use
Range(Activecell.Address)

Mark.

 

[Lowgrey]

Thanks!

I knew it had to be something obvious that I was missing...

Thanks!