Excel Macro Formula: Concatenate Gives a False Answer

[arnel_10]

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

[benishiryo]

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.

[MarvinP]

Hi Arnel,

Try this code and see the attached:

Please Login or Register  to view this content.

VBA All Sheets Formula.xlsm

[arnel_10]

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

[arnel_10]

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