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

 

[shades]

Howdy. You can do it with formula. Suppose data starts in cell A2, then in B2 put this formula:

="123-"&A2

Then copy down the entire column. (When you move mouse pointer to lower right corner of cell B2, and it turns into a crosshair, then double click and it will autofill the column as far as column A)

Or do you require VBA?
________
HEADSHOP

 

[esskaykay]

Excellent

Thanks,
SKK