Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Writing macro in Excel
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Writing macro in Excel
For Each cell in selection cell.value = cell.Value & "X" Next cell -- HTH Bob Phillips (remove nothere from email address if mailing direct) "CCB AA" wrote in message ... 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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Writing macro in Excel
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 -- tj "CCB AA" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Closing File Error | Excel Discussion (Misc queries) | |||
Relative Ranges in excel macro | Excel Worksheet Functions | |||
passing arguments from an excel macro to a word macro | Excel Discussion (Misc queries) | |||
Excel macro that opens new MS Word file and pastes data as a pictu | Excel Worksheet Functions | |||
Macro in Excel 2002 to save a workbook to a FTP location | Excel Discussion (Misc queries) |