Vba to replace cells with specific text to a value of another cell of the same row

  • I have range of data A1:H3000 but there are multiple rows that have value "-" in B:D, what code to replace all the "-" of the row to the value of cell F of that row,



    thanks in advance

  • Re: Vba to replace cells with specific text to a value of another cell of the same ro


    I adopted this code from someone, but it stucks halfway


  • Re: Vba to replace cells with specific text to a value of another cell of the same ro


    Hello,


    You could test following code


    Hope this will help

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

  • Re: Vba to replace cells with specific text to a value of another cell of the same ro


    Glad you could fix your problem ...:wink:


    Thanks a lot for your Thanks ... and for the Reputation points ...:dance:

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

Participate now!

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