Thread: Replace Formulas with Values
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
GS GS is offline
external usenet poster
  
Posts: 364
Default Replace Formulas with Values
Hi Mazo,

You could try this:

With Range("C6:C900")
.FormulaR1C1 = "=R[-2]C+R1C6"
.Value = .Value
End With

Regards,
Garry
Reply With QuoteReply With Quote