VBA if Cell contains date then automatically add text to a different cell

  • Logit,

    You are genious, right hit to the point but still giving me the below debugger for some reason :(


    See attached


  • I will do that friend


    Thanks so much... definitely the issue is on my end.


    Much appreciated, you're done ur part in perfect way.

  • Glad to help ... but let us know how things turn out.

    So Logit, I think I found where the issue is....


    The sheet that use is a working sheet with 620 rows, - only this one is returning the debugger... even if I put


    [code]For Each c In Source.Range("P1:P10000") ' Do 10000 rows

    If c = myString Then

    c.Offset(0, 6).Value = "delivered"[code]



    So When I run a shorter row sheet it works perfectly though...

  • .

    Use this macro instead. It determines how many rows are in use automatically. You don't need to set the maximum

    amount of rows.


  • .

    Use this macro instead. It determines how many rows are in use automatically. You don't need to set the maximum

    amount of rows.


    Nope, still the same issue Logit,



    Anyways thanks my friend for helping out, I'll figure out something


    You are the best my friend.

  • Try this


  • Try this


    ROY


    You are amazing... this is it...


    working flawlessly as it should be on the first place...


    Thanks guys, cant be more thankful.


    Warm greetings from Canada.

  • Pleased to help. I did suggest the Find method in Post #19 but you didn't reply to it.

    Actually yes, I saw it but Im still new to this and honestly didnt know how to start with the Find method ... so still learning, still a baby on this lol


    Thanks though, very appreciated to you Roy and Logit, ur rockstars.