Error: Displaying Formulas instead of values

[ramanujam]

Hi all,

While executing the macro in some columns am getting formulas instead of getting values of that formulas...

Like for example am getting like
=RIGHT(RC[-1],2)&"/"&MID(RC[-1],5,2)&"/"&LEFT(RC[-1],4) instead of the values...

Can anyone help me to solve this issue..
Thanks in advance....

 

[Weaver]

Any chance of posting the code you're using?

 

[ramanujam]

Hi.. thnaks for ur reply..

See how am using is that , to find the both column values are equal or not.

The macro i recorded is
Sub Match()
Range("C1").Select
ActiveCell.FormulaR1C1 = "=IF(RC[-2]=RC[-1],""True"",""False"")"
Range("C1").Select
Selection.AutoFill Destination:=Range("C1:C500")
Range("C1:C500").Select
Range("C1").Select
End Sub

In this am getting only the formulas are displayed instead of values like True or False...

It happens only at some times..
Can u help me to solve this issue...

Any chance of posting the code you're using?

 

[Yard]

Why not just

Sub Match()

Range("C1:C500").FormulaR1C1 = "=RC[-2]=RC[-1]"

End Sub

 

[RoryA]

Might be a Text formatting issue, but you can avoid that with a slight tweak to Yard's code:

Sub Match()
with Range("C1:C500")
   .NumberFormat = "General"
   .FormulaR1C1 = "=RC[-2]=RC[-1]"
End with

End Sub

 

[ramanujam]

Thanks all...
Thanks for ur replies..
Its working fine...

Might be a Text formatting issue, but you can avoid that with a slight tweak to Yard's code:

Sub Match()
with Range("C1:C500")
   .NumberFormat = "General"
   .FormulaR1C1 = "=RC[-2]=RC[-1]"
End with
 
End Sub

 

[Yard]

Good spot Rory