Cell selection in Excel - macro problem

[collierd]

Hello

Within Excel, using the following data:

     C1       C2        C3       C4       C5      ..to C13
R1           Leeds
R2
R3
R4   Sales   Jul-06   Aug-06   Sep-06   Oct-06    ..to Dec

I am trying to get the following results:

id
Leeds*Jul-06*Sales
Leeds*Aug-06*Sales
Leeds*Sep-06*Sales
Leeds*Oct-06*Sales
.. to Dec-06

I have the following code:

Dim rowReference As Integer
   Dim i As Integer
   
   rowReference = 2
   For i = 1 To 12
      ActiveCell.FormulaR1C1 = _
        "=budget!R1C2 & ""*"" & budget!R4C[1] & ""*"" & budget!R[-3]C1"
      Range("A" & rowReference).Select
      rowReference = rowReference + 1
   Next i

The problem lies with budget!R4C[1] & ""*"" & budget!R[-3]C1
How do I get this to make use of the variable i in its selection?

Thanks

Damian.

 

[collierd]

Fixed it:

Seems to be where the quotes are

"=budget!R1C2 & ""*"" & budget!R4C[" & i & "] & ""*"" & budget!R4C1"