Revised Excel VB question

[Rexxx]

I have the following Excel VB script:

ActiveSheet.Cells(8,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(8,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]

Have u got 2 user names?
Anyway,

"$C$i" should read "$C$" & i

Nick

 

[zcjl]

You can do like this:

Dim i As Integer
for i=2 to 100
ActiveSheet.Cells(8,14).Formula = "=$C$" & i
next i