Hi

I have a formula in a certain cell and then use the AutoFill-fuction

Range("C6").FormulaR1C1 = "=R[-2]C+R1C6"
Range("C6").Select
Selection.AutoFill Destination:=Range("C6:C900"),
Type:=xlFillDefault

Later I want to use the Values of Range("C6:C900")

How can I get the values?
Or:
Can I use the AutoFillfunction also for Range("C6").Value = ?? ?


Mazo