sub trimten()
for each c in selection
c.value=left(c,10)
next

"Nicola Debiasi" wrote in message
...
Hi all



I have a problem when recording a macro with excel, the problem is that I
am
unable to record relative movement that I do when I selected a cell. I
explain better: I have a list of names and I have to cut them to maximum
10
characters, so I copy one (with relative button on) and paste it in
another
place, then I select that cell, edit it and push the right arrow ten times
starting to the extreme left, than I cancel anything else. Excel do not
record my movements, but memorize only the result.

Is there a way to make relative, when recording, even my movement when
editing the text of a cell.



Thank you in advance

Nicola