Can anyone tell me why this errors:
Set resSheet = Workbooks("Results.xlsm").Worksheets("Data")
pRow = 5
pCol = 68
Set pasteSummary = resSheet.Cells(pRow, pCol)
I use the cells property all of the time; but it seems to fail whenever I try to mix it with any other parts of a...