Hi Debra,

I'm not in the least bit knowledgable on macros & I'm just using the recorder.
I have gone about doing what i wanted to do another way, but I still need to
know how to do this so I can do other macros.

I wanted to go in a cell, cursor past social secuirty numbers that is right
next to names, so that only the name would be left would be the name. then
keep going down the column & run the macro in all the other cells.

1. I have cells that have a social security number & the persons name next
to it
2. I want the cell only to have the name in it
3. so I try to record a macro
4. I put the cursor at the beginning of the cell
5. I take the cursor & do control arrow over until it goes past the social
security number
6. then backspace to the beginning of the cell
7. that gets rid of the social security number & leaves only the names
8. then hit enter & the cursor goes down one row (which I want)
9. then I stop the recorder
10 then I do the same thing in that row below it
11 but what happens is the name from the above cell appears in that cell
12 it happens no matter what row I put the cursor in - if it is 20 rows
below the row I made the macro in
13. so i thought it is a relative problem
14 so i hit that relative button at least 20 times doesn't make a difference

any chance can you help me?

"Debra Dalgleish" wrote:

What do you want the macro to do?
What steps to you do while recording the macro?

What does the recorded code look like?

harriet wrote:
I'm trying to record a macro. I record it in a cell. When I run it in another
cell it puts the data from the cell I recorded it in in the new cell. I
don't think it is using a relative reference. I have the stop recording
button in view & I have selected relative reference but it still keeps
refering back to the original cell I made the macro in. I sure need help,
I'm going nuts.

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html