Excel cell giving blank value for the concatenate formula

[sharmila Krishnamurthy]

Hi All

Could any one help me with the below problem statement

Problem statement : The Excel cell is not returning the result, the cell is blank. while checking the formula bar displaying the formula

Below is the statement used:

Range("C6").formula = "=RC1&RC2"

 

[AlanSidman]

change to

Range("C6").formulaR1C1 = "=RC1&RC2"

 

[sharmila Krishnamurthy]

change to

Range("C6").formulaR1C1 = "=RC1&RC2"

change to

Range("C6").formulaR1C1 = "=RC1&RC2"

Thanks Much, this is working