output to empty cell range..

  • Excel Expertise,


    i am trying to split the word from a sentence and select the alphanumeric word from the sentence. The selected word need to be printed/filled in the same sheet to a specifi range, but i succeded to get the output to a msg box. Input is from one cell range and my requirement is to have the ouput to different range where the cell value is null kindly help. Pasted code for your refrence




  • Re: output to empty cell range..


    I am assuming you have another function called IsAlphaNumeric? This determines if the string is composed of only alphabet (a-z) and/or numbers? I assume you are trying to write to Sheet2 in column L? If no to any of these then you need to be more specific or supply a sample workbook - you could try something like

    Regards
    [SIZE=3]Anthony
    [/SIZE]&WCF_AMPERSAND[SIZE=3]
    [/SIZE]&WCF_AMPERSAND&WCF_AMPERSAND&WCF_AMPERSAND[SIZE=2]You have your way. I have my way. As for the right way, the correct way, and the only way, it does not exist.[/SIZE]




Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!