Hi, I wrote a Macro that runs two different web queries. What I need to do is
make them work on different sheets.

Here's part of it:

'Dim strCnn As String
strCnn = "URL;" & Range("B6").Text
With ActiveSheet.QueryTables.Add(Connection:=strCnn,
Destination:=Range("B10"))
.FieldNames = True
.RowNumbers = False
.FillAdjacentFormulas = False
.PreserveFormatting = True

I want this one to work on a specific sheet, not the activsheet!

Many thanks,
Alex