+ Reply to Thread
Results 1 to 7 of 7

How to Improve my VBA formula ?? find some space cell at rows and input some word inside

  1. #1
    Registered User
    Join Date
    05-04-2015
    Location
    Hong Kong
    MS-Off Ver
    2010
    Posts
    19

    How to Improve my VBA formula ?? find some space cell at rows and input some word inside

    Hi All

    I have some question about my VBA formula

    Orginal

    error1.jpg

    the result

    result001.jpg

    my vba

    Please Login or Register  to view this content.

    If i try this is work at column A

    but if try the following VBA is not working
    any brother can teach me how to improved

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by jayshing; 02-07-2021 at 09:18 PM.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    36,778

    Re: How to Improve my VBA formula ?? find some space cell at rows and input some word insi

    Administrative Note:

    We would very much like to help you with your query, however you need to include code tags around your code.

    Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

    Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

    (Note: this change is not optional.)

  3. #3
    Registered User
    Join Date
    05-04-2015
    Location
    Hong Kong
    MS-Off Ver
    2010
    Posts
    19

    Re: How to Improve my VBA formula ?? find some space cell at rows and input some word insi

    Noted and Changed

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    36,778

    Re: How to Improve my VBA formula ?? find some space cell at rows and input some word insi

    Thank you. I'll try and have a look later.

  5. #5
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    20,146

    Re: How to Improve my VBA formula ?? find some space cell at rows and input some word insi

    1) You can not declare same variable mother than once within a procedure.
    2) You need to take last row from col.D.
    Please Login or Register  to view this content.
    3) this also should work.
    Please Login or Register  to view this content.

  6. #6
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    36,778

    Re: How to Improve my VBA formula ?? find some space cell at rows and input some word insi

    Maybe

    Please Login or Register  to view this content.

  7. #7
    Registered User
    Join Date
    05-04-2015
    Location
    Hong Kong
    MS-Off Ver
    2010
    Posts
    19

    Re: How to Improve my VBA formula ?? find some space cell at rows and input some word insi

    Quote Originally Posted by jindon View Post
    1) You can not declare same variable mother than once within a procedure.
    2) You need to take last row from col.D.
    Please Login or Register  to view this content.
    3) this also should work.
    Please Login or Register  to view this content.
    Dear jindon

    You are correct and Noted

    Perfect !!! solved my problems

+ 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] How to input Cell reference inside a {}
    By archvanarl in forum Excel General
    Replies: 6
    Last Post: 08-20-2020, 09:06 AM
  2. [SOLVED] move value to next line for every space inside cell
    By k1dr0ck in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-17-2019, 01:08 AM
  3. Replies: 7
    Last Post: 05-11-2019, 12:38 PM
  4. [SOLVED] Use an input variable inside a formula
    By fabien1 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-27-2019, 07:26 PM
  5. [SOLVED] Using Sumproduct to find a containing word inside a cell
    By bouncingbudha in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-14-2014, 09:28 PM
  6. [SOLVED] formula for 'pick out the first word of the cell up until the space'
    By johnandrews in forum Excel General
    Replies: 3
    Last Post: 03-12-2014, 08:51 AM
  7. Replies: 2
    Last Post: 10-05-2007, 06:12 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.08459 seconds
  • Memory Usage 9,100KB
  • Queries Executed 16 (?)
More Information
Template Usage (36):
  • (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
  • (7)bbcode_code
  • (1)bbcode_quote
  • (1)footer
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)headinclude_bottom
  • (7)memberaction_dropdown
  • (1)navbar
  • (4)navbar_link
  • (4)navbar_noticebit
  • (6)option
  • (1)postbit_attachment
  • (7)postbit_legacy
  • (7)postbit_onlinestatus
  • (7)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 (49):
  • 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_attachment
  • 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