Hi Galimi,
I've done that bunches of times & it makes no difference.

harriet

"galimi" wrote:

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!!