Thread: Recording macro
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Cliff Myers Cliff Myers is offline
external usenet poster
 
Posts: 48
Default 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