# Excel Macro Formula: Concatenate Gives a False Answer

1. ## 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

2. ## Re: Excel Macro Formula: Concatenate Gives a False Answer

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.``

3. ## Re: Excel Macro Formula: Concatenate Gives a False Answer

Hi Arnel,

Try this code and see the attached:
``Please Login or Register  to view this content.``
VBA All Sheets Formula.xlsm

4. ## Re: Excel Macro Formula: Concatenate Gives a False Answer

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

5. ## Re: Excel Macro Formula: Concatenate Gives a False Answer

Hi MarvinP,

Thank you so much and have a great day ahead!

Warmest regards,
Arnel

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

## X vBulletin 4.1.8 Debug Information

• Page Generation 0.07536 seconds
• Memory Usage 9,000KB
• Queries Executed 16 (?)
Template Usage (34):
• (3)bbcode_code
• (1)footer
• (1)forumrules
• (1)gobutton
• (5)memberaction_dropdown
• (1)navbar
• (4)navbar_noticebit
• (6)option
• (5)postbit_legacy
• (5)postbit_onlinestatus
• (5)postbit_wrapper
• (1)spacer_close
• (1)spacer_open
• (1)tagbit_wrapper

Phrase Groups Available (6):
• global
• inlinemod
• postbit
• posting
• reputationlevel
Included Files (39):
• ./vbseo.php
• ./env.php
• ./vbseo/includes/functions_vbseo.php
• ./vbseo/includes/functions_vbseo_pre.php
• ./vbseo/includes/functions_vbseo_url.php
• ./vbseo/includes/functions_vbseo_createurl.php
• ./vbseo/includes/functions_vbseo_db.php
• ./vbseo/includes/functions_vbseo_vb.php
• ./vbseo/includes/functions_vbseo_seo.php
• ./vbseo/includes/functions_vbseo_misc.php
• ./vbseo/includes/functions_vbseo_crr.php
• ./vbseo/includes/functions_vbseo_cache.php
• ./vbseo/includes/functions_vbseo_hook.php
• ./vbseo/includes/functions_vbseo_startup.php
• ./includes/config.php
• ./global.php
• ./includes/class_bootstrap.php
• ./includes/init.php
• ./includes/class_core.php
• ./includes/functions.php
• ./includes/class_friendly_url.php
• ./includes/class_hook.php
• ./includes/functions_cforum.php
• ./includes/functions_bigthree.php
• ./includes/class_postbit.php
• ./includes/class_bbcode.php
• ./includes/functions_reputation.php
• ./includes/class_bootstrap_framework.php
• ./vb/vb.php
• ./vb/phrase.php
• ./packages/vbattach/attach.php
• ./vb/types.php
• ./vb/cache.php
• ./vb/cache/db.php
• ./vb/cache/observer/db.php
• ./vb/cache/observer.php
• ./includes/functions_notice.php

Hooks Called (48):
• init_startup
• friendlyurl_resolve_class
• database_pre_fetch_array
• database_post_fetch_array
• global_bootstrap_init_start
• global_bootstrap_init_complete
• cache_permissions
• fetch_foruminfo
• global_state_check
• global_bootstrap_complete
• global_start
• style_fetch
• global_setup_complete
• friendlyurl_redirect_canonical
• bbcode_fetch_tags
• bbcode_create
• postbit_factory
• postbit_display_start
• cache_templates
• template_register_var
• parse_templates
• notices_check_start
• notices_noticebit
• process_templates_complete
• reputation_image
• postbit_imicons
• bbcode_parse_start
• bbcode_parse_complete_precache
• bbcode_parse_complete
• postbit_display_complete
• memberaction_dropdown
• tag_fetchbit_complete