Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to edit cells
I’m trying to add a number and a hyphen (i.e., 123-) to the values i all cells in a column. Under the old Lotus 123 DOS days, my macro cod 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, SK -- esskayka ----------------------------------------------------------------------- esskaykay's Profile: http://www.excelforum.com/member.php...nfo&userid=871 View this thread: http://www.excelforum.com/showthread.php?threadid=57011 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to edit cells
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: Im 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, Im 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Record Macro and Edit Macro options disabled | New Users to Excel | |||
how to edit cells | New Users to Excel | |||
How to use macro to edit data in Excel cells | Excel Discussion (Misc queries) | |||
Macro to edit cells | Excel Programming | |||
How do Macro to EDIT cells? | Excel Programming |