+ Reply to Thread
Results 1 to 5 of 5

Excel Macro Formula: Concatenate Gives a False Answer

  1. #1
    Registered User
    Join Date
    03-01-2017
    Location
    Manila, Philippines
    MS-Off Ver
    MS Office 2007
    Posts
    77

    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. #2
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,142

    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. #3
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,860

    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
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  4. #4
    Registered User
    Join Date
    03-01-2017
    Location
    Manila, Philippines
    MS-Off Ver
    MS Office 2007
    Posts
    77

    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. #5
    Registered User
    Join Date
    03-01-2017
    Location
    Manila, Philippines
    MS-Off Ver
    MS Office 2007
    Posts
    77

    Re: Excel Macro Formula: Concatenate Gives a False Answer

    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Getting a false answer
    By Kingdazza007 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-18-2016, 01:32 AM
  2. [SOLVED] Excel Concatenate formula or macro based on array
    By mcranda in forum Excel General
    Replies: 0
    Last Post: 10-19-2015, 03:44 PM
  3. [SOLVED] Multiple fields and want only 1 answer = TRUE or = FALSE
    By edanielqsf in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 04-23-2014, 08:10 PM
  4. If statement, answer is false, hide false.
    By Mel B in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-07-2013, 06:36 PM
  5. [SOLVED] FALSE answer displayed on formula - should work!
    By sna400 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-08-2013, 09:31 AM
  6. Replies: 1
    Last Post: 08-20-2011, 06:51 AM
  7. Replies: 6
    Last Post: 06-06-2006, 01:25 PM

Bookmarks

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 (?)
More Information
Template Usage (34):
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_global_above_footer
  • (1)ad_global_below_navbar
  • (1)ad_global_header1
  • (1)ad_global_header2
  • (1)ad_navbar_below
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)ad_thread_first_post_content
  • (1)ad_thread_last_post_content
  • (3)bbcode_code
  • (1)footer
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)headinclude_bottom
  • (5)memberaction_dropdown
  • (1)navbar
  • (4)navbar_link
  • (4)navbar_noticebit
  • (6)option
  • (5)postbit_legacy
  • (5)postbit_onlinestatus
  • (5)postbit_wrapper
  • (4)showthread_bookmarksite
  • (7)showthread_similarthreadbit
  • (1)showthread_similarthreads
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper
  • (1)vbseo_linkbackmenu_entry 

Phrase Groups Available (6):
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
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
  • ./showthread.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_facebook.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_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • global_state_check
  • global_bootstrap_complete
  • global_start
  • style_fetch
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • friendlyurl_redirect_canonical
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • fetch_musername
  • 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
  • showthread_similarthread_query
  • showthread_similarthreadbit
  • forumrules
  • showthread_bookmarkbit
  • navbits
  • navbits_complete
  • showthread_complete


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1