jeudi 15 juillet 2021

Trying to Change a Select Number of Words in a Column Into a Different Word Excel VBA

I am currently trying to create a macro that will look down an entire column, and if the word equals a certain word, it would then be changed to the more appropriate word.

For example, every time the animal 'Bird' was located in column B, it would be turned into the word 'Parrot'. If, while searching down column B, it came across the word 'Dog' or 'Cat', the word would remain the same.

Any help would be greatly appreciated! Thank you!!

Aucun commentaire:

Enregistrer un commentaire