Help with SET and worksheet object

[Johnny C]

Hi

I'm trying to copy from a template to a worksheet object, but am getting a "Method 'Range' of object '_Worksheet' failed" error (1004)

It has no problem setting the name, why can't I use a range with it?

    Set QueryOutputWkSht = Sheets.Add
    QueryOutputWkSht.Name = "Query Log"
    strQueryLogRangeRefOutput = "$A$1:" & Cells(9, wksQueryLog.Cells.SpecialCells(xlLastCell).Column).Address(True, True, xlA1)
    wksQueryLog.Range(strQueryLogRangeRef).Copy Destination:=QueryOutputWkSht.Range("A1")

Cheers

 

[RoryA]

What is strQueryLogRangeRef?

 

[Johnny C]

Doh, it was copied into a small sub - should have been strQueryLogRangeRefOutput as strQueryLogRangeRef was defined elsewhere in the big sub.

Works now.

I've been wrangling with Set and workbook/sheet objects all morning so assumed it was yet another misunderstanding on my part, stupid me forgot to look for the simple things