Why is my AE column not updating?

[Potatokat]

Hi everyone,

I am very new to VBA and have been learning it for work.

I am trying to create a macro button that will help me update the the value in the AE column to "N" if the value in the same row of the H column is "REPO".

I am not sure why my code doesn't work properly and just seems to select the AE column when I run it instead of changing the values to "N"

Thanks for the help in advance!

Any input would be much appreciated!

 

[Joe4]

That should work.

Are you sure that the value in column H equals EXACTLY "REPO"?
Any additional characters, like a space or some other special character, will cause it NOT to match.

Also, do you have any VBA code in the "expo" sheet module in VBA?
That is where any automated code that might affect the worksheet would exist (could be something interfering with it).

 

[Potatokat]

That should work.

Are you sure that the value in column H equals EXACTLY "REPO"?
Any additional characters, like a space or some other special character, will cause it NOT to match.

Also, do you have any VBA code in the "expo" sheet module in VBA?
That is where any automated code that might affect the worksheet would exist (could be something interfering with it).

Thank you! You are right, there was a space in "REPO" values so it didn't work properly. It works fine after I fixed that!

 

[Joe4]

You are welcome.
Glad I was able to help!