Expected: List Separator or ) Error: SYNTAX

[SBF12345]

Greetings,

I am receiving an "expected: list separator or )" on the following line.

C = PA.ws.Range(Cells(D, "A"): Cells(G, "A")).Rows.Count

I am trying to set an integer variable for a range of cells defined by other integer variables. Where is the error?

 

[admiral100]

Try this :

C = PA.ws.Range(Cells(D, "A") & ":" & Cells(G, "A")).Rows.Count

 

[Joe4]

I had to change it to this in order to get it to work without errors for me:

[COLOR=#333333]C = PA.ws.Range(Cells(D, "A"), Cells(G, "A")).Rows.Count[/COLOR]

 

[Norie]

Couldn't you just calculate the difference between D and G?

By the way, I can see various other potential problems with the code.

For example, what does PA.ws refer to?

If PA is a workbook reference then it won't have a property ws, even if ws is a reference to a worksheet in the workbook PA.

 

[SBF12345]

Thanks, I went with the comma version and the text color is no longer red...Thanks!