Object doesn't support this property or method: Error

[SBF12345]

Greetings,

The line below is giving me a runtime error "Object doesn't support this property or method"

A = PA.ws.Range(Cells(Rows.Count, "A")).End(xlUp).Row

A is an integer variable. Can I use ".row" with an integer variable?

 

[Norie]

The problem is with PA.ws.

Based on your previous posts PA is a workbook reference and ws is a worksheet in that workbook so all you need is ws.

Oh and you don't need Range(Cells(...)), so.

A = ws.Cells(Rows.Count, "A").End(xlUp).Row