Macro to edit cells

[esskaykay]

I’m trying to add a number and a hyphen (i.e., 123-) to the values in all cells in a column. Under the old Lotus 123 DOS days, my macro code would read something like:

{edit}{home}123-{down}~

However, now with Excel, and VBA, I’m having a real problem do this. Any ideas?

Thanks,
SKK

[MSweetG222]

SKK -

Consider using a formula instead....

ColA ColB
---------- -------------
1 ABC =A1&"-123" <<< if it goes on back end
2 XYZ ="123-"&A2 <<< if it goes on front end
3
4

Then just copy / paste values (Edit | Copy, Edit | Paste Special | Values).
I think that will be much faster for you. Hope that is what you need.
--
Thx
MSweetG222



"esskaykay" wrote:

>
> I’m trying to add a number and a hyphen (i.e., 123-) to the values in
> all cells in a column. Under the old Lotus 123 DOS days, my macro code
> would read something like:
>
> {edit}{home}123-{down}~
>
> However, now with Excel, and VBA, I’m having a real problem do this.
> Any ideas?
>
> Thanks,
> SKK
>
>
> --
> esskaykay
> ------------------------------------------------------------------------
> esskaykay's Profile: http://www.excelforum.com/member.php...fo&userid=8715
> View this thread: http://www.excelforum.com/showthread...hreadid=570117
>
>