Recording a macro in Excel

CathyDAquarius · #1 Dec 18, 2007, 02:10 PM

Need a macro that will select the cell one place to the left, edit the content, hit enter, and then move to cell below where started and repeat to end of column (last cell with a value).

Example: 123-456789 is format of cell to be edited - need to remove the hyphen.

Someone had created it for me - and I know they used Concatenate...., but I cannot do it - if I record, it is always going to same cell.

Thank you.

mdosh01 · Dec 19, 2007, 05:17 AM

It sounds like you are using the "Record New Macro" function in Excel. Is that correct? Or will you be editing the macro directly in the editor?

Also, the use of concatenate is a different issue from it always going to the same cell.

What version of Excel are you using?

Sorry can't more immediately.



At Ask Me Help Desk you can ask questions in any topic and have them answered for free by our experts. To ask questions or participate in answering them you must register for a free account. By registering you will be able to: Get free answers from experts in any of our 300+ topics. Accept money for answers that you provide. Communicate privately with other members (PM). See fewer ads. Sign Up!