i am trying to let the bot replace my excel’s cell that contain [!*]
Asterik is that anything can be in between. e.g. [!1], [!1,2,3], [!1,3]
to find if it contain above and remove it & replace with next cell’s value.
i created a For each row, and if statement, but seems like when i debug, it just went pass the If statement. Any help is appreciated!