Macro to edit, enter, down

[WyoDave]

I have a column with text, but some shows as left justifed unless i hit 'edit (F2)', 'enter'.

How can i fix that - OR - how can i write a macro that works with i put the curser in any cell, then the macro runs edit, enter, down and then repeats to the bottom of the data in that column?

I used to run Lotus and could understand macro language there pretty good. visual basic has me stumped

 

[Rick Rothstein]

I have a column with text, but some shows as left justifed unless i hit 'edit (F2)', 'enter'.

How can i fix that - OR - how can i write a macro that works with i put the curser in any cell, then the macro runs edit, enter, down and then repeats to the bottom of the data in that column?

I used to run Lotus and could understand macro language there pretty good. visual basic has me stumped

Give this a try and see if it works. Select the column or columns with these cell in them, then press ALT+F11 to go into the VB editor and execute the following line of code in the Immediate Window (press CTRL+G if you do not see it)...

Selection.Formula = Selection.Formula