Cells property problems

[davidam]

Hello Everyone,
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 range property.
Many thanks,
David

 

[NoSparks]

Can you elaborate on what you mean by errors ?

Not knowing what the actual situation is, I tested it this way and it selected "BP5" as I would expect.

Sub testing()

Set resSheet = ThisWorkbook.Worksheets("Data")
 pRow = 5
 pCol = 68
Set pastesummary = resSheet.Cells(pRow, pCol)
pastesummary.Select

End Sub

 

[davidam]

Solved. Thanks

 

[davidam]

I appreciate the response. It seems that I had not properly dimensioned the variable pCol. Thanks again