Cell value gives false

Important Notice


Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.

  • I am fairly conversant with excel vba. a party has sent me a file. in one of the sheets the cell B4 has the value "Client1". the macro I wrote gave me some problem.


    for checking in immediate window I typed




    ?range("B4")="Client1" (no spelling mistake)
    this gives me


    FALSE


    WHY????


    I also tried "cellview" addin of Pearson. that gave only 7 characters and no non printing character
    is the sheet or cell locked or blocked somehow??

    I am not an expert. better solutions may be available. $$$venkat$$$1926@$$$gmail.com

  • Re: Cell value gives false


    I believe it's because your code is asking a question. What would you like the result to be?

    [SIZE=3]The Only Dumb Question Is A Question Not Asked.[/SIZE]

  • Re: Cell value gives false


    yegarboy
    let me apologize. in client1 "C" is in caps that seemed to have given the problem. My statement "no spelling mistake" is wrong and many regrets.


    many many thanks. even though I have written many macros I never expected I would do such silly mistake. perhaps brain is not working efficiently this day.

    I am not an expert. better solutions may be available. $$$venkat$$$1926@$$$gmail.com

  • Re: Cell value gives false


    yegarboy


    I could have use "option compare text". that also I missed


    ROY


    apologise for not tagging the code. Shall keep in mind

    I am not an expert. better solutions may be available. $$$venkat$$$1926@$$$gmail.com

Participate now!

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