Harriet,
The button next to the Stop Recording button is the Relative Reference
recording. Try clicking that to see if you get the desired results.
http://HelpExcel.com
"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.
thank you in advance!!