|Yes more detail will be needed, you can almost achieve anything in VBA, well within reason of course. What you need to do is be more specific about what you are trying to achieve, also give us an idea of what you are producing so we are on the same page. Then we can help. What you have described above about AA11 to AA is pretty easy. When you say paste, do you mean you want AA to be entered into a cell?|
So under the sheets "Sheet Change" method you would do something like
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$1" Then
If Target.Value = "AA11" Then
Target.Value = "AA"
This checks to see if sheet1, range A1 changes, and if the value in A1 = AA11 then it changes it to AA
This is a very quick example there are better approached, but it works