Macro

dneas · Mar 12th, 2002, 07:17 AM

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 · Mar 12th, 2002, 07:20 AM

Quote:

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,

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 12th, 2002, 07:17 AM	#1
dneas New Member Join Date: Mar 2002 Posts: 34	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?