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.
--
Kevin Backmann


"notthemacroman" wrote:

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.