How to fix the cell in programming?

[vinitdhuri]

I have a formula
Sub Macro2()
'
' Macro2 Macro
' Macro recorded 17.05.2012 by URDHUV
'


For x = 1 To 10
ActiveSheet.Range("AD" & x).Select
ActiveCell.FormulaR1C1 = _
"=CONCATENATE(RC[-1],"" "",RC[-12],RC[-11],"" "",RC[-10],RC[-9])"
Next x

End Sub

Here instead of RC[-1] i want to use $AC$2 and fix that cell in the formula;

Please guide me how to do that?

[vinitdhuri]

I think i got the solution i just put the number :-)
as R2C29 and now this cell is remaining fixed.

[Trebor76]

Hi vinitdhuri,

Try this:

Please Login or Register  to view this content.

HTH

Robert