Recording macro
 

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

Recording macro
 

To my knowledge no. But to help you out with your 10 character thing. If
your text is in cell A1 enter this in B1:
=Left(A1,10)
now B1 will show 10 characters including spaces, whatever is in cell A1.
HTH

"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

Recording macro
 

Try this with the list in Column A

Sub Test()
For Each cell In Columns("A").SpecialCells(xlCellTypeConstants)
cell.Value = Left(cell.Value, 10)
Next
End Sub



--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"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

Recording macro
 

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

Recording macro
 

Thank you all guys! (to Cliff in particular for his brilliant and incredibly
simple solution!) Now everithing is very easy!

Nicola

"Cliff Myers" ha scritto nel messaggio
...
To my knowledge no. But to help you out with your 10 character thing. If
your text is in cell A1 enter this in B1:
=Left(A1,10)
now B1 will show 10 characters including spaces, whatever is in cell A1.
HTH

"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

Recording macro
 

Hi Nicola

If you choose for the formula you can copy it and do a Paste specal to values
You can delete the A column after that

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Nicola Debiasi" wrote in message ...
Thank you all guys! (to Cliff in particular for his brilliant and incredibly
simple solution!) Now everithing is very easy!

Nicola

"Cliff Myers" ha scritto nel messaggio
...
To my knowledge no. But to help you out with your 10 character thing. If
your text is in cell A1 enter this in B1:
=Left(A1,10)
now B1 will show 10 characters including spaces, whatever is in cell A1.
HTH

"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

Recording macro
 

Thank you very much Ron, I have copied the formula on my computer, I am sure
it will be very useful!

thank you again!
Nicola

"Ron de Bruin" ha scritto nel messaggio
...
Hi Nicola

If you choose for the formula you can copy it and do a Paste specal to
values
You can delete the A column after that

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Nicola Debiasi" wrote in message
...
Thank you all guys! (to Cliff in particular for his brilliant and
incredibly
simple solution!) Now everithing is very easy!

Nicola

"Cliff Myers" ha scritto nel messaggio
...
To my knowledge no. But to help you out with your 10 character thing.
If
your text is in cell A1 enter this in B1:
=Left(A1,10)
now B1 will show 10 characters including spaces, whatever is in cell
A1.
HTH

"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