I need help writing a macro that will correct typing errors?

[Guest]

I need a macro that when selected, will correct cell inputs.....
ex. What I want in the column/row of cells is AAAA.

What I have been given is AAA B, AA, AAAAA.

I would like to correct these with a macro.

Any help would be great, thanks.

 

[Guest]

You can do this with AutoCorrect. Click TOOLS and select AUTOCORRECT OPTIONS
and add what you want to trap and what you want to replace it with.

A lot easier that writing code.

 

[bgeier]

Could you be a bit more specific?
Do you want any value in the cell to be changed to "AAAA" or changes
made based on some other criteria?

 

[bgeier]

I concur with Kevin's suggestion, however, autocorrect will change al
occurrences no matter where they are entered. You will have t
restrict (lock) cells where you do not want a user to enter data