Find Value in specific Range then if it's not match Replace it via Input Box

  • Hi Everyone can Anyone Help me, I am new to VBA macro and I wanted to have a solution you see I have a code that have an array, I need to find it in each cell and if it doesn't match to the array I set up. I need to replace it via input box. Thank you

  • Could you attach a copy of your file including any macros you are currently using? It would be easier to see how your data is organized and to test possible solutions. Include a detailed explanation of what you want to do using a few examples from your data and referring to specific cells, rows, columns and sheets. De-sensitize the data if necessary.

    You can say "THANK YOU" for help received by clicking the "Like" icon in the bottom right corner of the helper's post.
    Practice makes perfect. I am very far from perfect so I'm still practising.

Participate now!

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