Pasting an Integer Variable Value into a Worksheet

[SBF12345]

Greetings,

I would like to paste an integer variable value into a cell on a worksheet. Here is a bit of the code I am working with.

C is the variable

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

The code below gives a compile error at "C.Copy"

C.Copy                TA.ws.Range("A1").End(xlDown).Offset(0, 5).Select
                Selection.Paste PasteSpecial:=xlValues

I would like to copy the number of rows into a cell on a worksheet. Other methods?

 

[Rick Rothstein]

Greetings,

I would like to paste an integer variable value into a cell on a worksheet. Here is a bit of the code I am working with.

C is the variable

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

The code below gives a compile error at "C.Copy"

C.Copy                TA.ws.Range("A1").End(xlDown).Offset(0, 5).Select
                Selection.Paste PasteSpecial:=xlValues

I would like to copy the number of rows into a cell on a worksheet. Other methods?

Your question is not entirely clear to me. Just a guess... assume D=5 and G=9 as an example, are you trying to copy the data in the cells A5:A9 into one single cell or are you trying to put the count of the number of cells in the range A5:A9 (5 total cells) into that one single cell? Or are you trying to do something else instead?

 

[mikerickson]

One doesn't copy variables. But one can put a variable into a cell (without Paste, since Paste is for Copied things)

TA.ws.Range("A1").End(xlDown).Offset(0, 5).Value = C

 

[SBF12345]

I am shooting for the count value of the range using the two other variables.

Thanks, I can assign the value with the .value = C