(Solved) – VBA: How to find a value in cell B(x) and replace value in C(x). Offset by 1


I’d like to ask for some excel VB help.

I have a column B in the range B1:B31. The text contains the words “Enabled”, or “Disabled”. My goal is that when a button is clicked, the code would loop through all the values in the range B1:B31, and if it finds the text “Enabled”, it will replace the next column (same row) over with a value. I believe this is offset (0,1).

Example. So as the code is scanning the range, it comes across cell B3, if it find the word “Enabled” in this cell, then it will insert ] the value from the default time estimate into cell C3.

Here is an illustration:
enter image description here

Leave a Reply

Your email address will not be published. Required fields are marked *