Excel Macro Formula: Concatenate Gives a False Answer

Hi excelforum Experts,

I am trying to use Concatenate formula in cell A3 of each worksheet in a workbook as =concatenate(A4," ",B4) but it gave me FALSE as an answer across all worksheets.

Here is the code that I am referring to:

ws.Range("A3") = ActiveCell.FormulaR1C1 = "=CONCATENATE(A4,B4)"

I appreciate if there could be someone that could help me fix this formula. Thank you!


Warmest regards,
Arnel

hi arnel. what is the activecell for? arent' you already specifying you want the formula inside cell A3? and when you do two equals like this below, it is doing a logical test:
ws.Range("A3") = ActiveCell.FormulaR1C1

it will return TRUE or FALSE. you are asking if ws.Range("A3") is equals to activecell.formular1c1.

secondly, if you use FormulaR1C1, you must use the R1C1 style. that is:

Please Login or Register  to view this content.

that means to refer to 1 row below A3 in the same column (A), and 1 row below A3 and 1 column after (B4).

if you wish to use A4,B4, use:

Please Login or Register  to view this content.

Hi benishiryo,

Thanks for pointing this out and for helping me understand how the code works. I admit I overlooked those two equal signs and I am glad you explain what would be the outcome.

Anyway, I really appreciate your inputs and explanations. Thank you so much!

Warmest regards,
Arnel

Hi MarvinP,

Thanks for your additional inputs. This will be added to my notes for my future reference.

Thank you so much and have a great day ahead!


Warmest regards,
Arnel