Macro

[dneas]

In Excel how do you create a macro to similuate keystrokes. If I have a set of data 123.00- and the needs to be put in front, In Lotus I would normally write a macro like this: edit,bs,home,-,enter but in Excel it changes the numbers as you go down the list? I tried changing from absolute but it still copied the numbers from the previous cells?

 

[Barrie Davidson]

On 2002-03-12 06:17, dneas wrote:
In Excel how do you create a macro to similuate keystrokes. If I have a set of data 123.00- and the needs to be put in front, In Lotus I would normally write a macro like this: edit,bs,home,-,enter but in Excel it changes the numbers as you go down the list? I tried changing from absolute but it still copied the numbers from the previous cells?

You can achieve this via a formula. Try this:

=IF(RIGHT(A1,1)="-",LEFT(A1,LEN(A1)-1)*-1,A1)

You can then copy the new values and Paste|Special|Values over-writing your old values.

Regards,