VB Excel Question

[sthmpsn1]

I have the following Excel VB script:

ActiveSheet.Cells(i, 14).Formula = "=$C$2"

What I would like to do is the following:

Dim i As Integer
i=2
Do
i=i+1
ActiveSheet.Cells(i, 14).Formula = "=$C$i"
Loop until i >100



But Formula does not read i as an integer. What other way can

this be written?

 

[nickjar2]

u will need to do it like:

"=$C$" & i

Nick