Writing macro in Excel

C

CCB AA

I have a column of numbers, 4 numbers to a cell. I want to add an X at the
end of numbers in various cells. I double click on the cell, the curser
moves to the end of the number and I add an X. I move to the nexrt cell down
and repeat. When I do this with a macro, instead of adding just the X, it
writes in the number from the first cell and the X. How do I do make the
macro only add a X to the current number?
 
B

Bob Phillips

For Each cell in selection
cell.value = cell.Value & "X"
Next cell

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
T

tjtjjtjt

I don't think you can do that with the recorder. Unless you have a way to
identify all of the numbers ahead of time, you can use the macro below. Just
click on the cell you want to add an X to and run the macro.
You will have to copy and past the code into your module.

Sub EndWithX()
ActiveCell.Value = ActiveCell.Value & "X"
End Sub
 
Top