Hi All,

I have run into the above error while trying to use variables for workbook and worksheet names. The workbook in question is the active workbook and the sheet exists. I have tried searching for the solution, but I have not found it and I can't figure it out. There may be other ways to do it, but I would like to know what is wrong with this code please.

Dim wkbDest As Workbook
Dim TP As Worksheet
Set wkbDest = Workbooks("Table Plan for Cameron.xlsm")
Set TP = Worksheets("TablePlan")
wkbDest.TP.Range("A1:H24").Clear      ' This is where the error 438 happens
Many thanks.