sounds like you are confusiong relative/absolute referencing with R1C1 style
referencing. There is no recording mode that records in R1C1 style. Some
actions are recorded as R1C1, but most are recorded as A1 style. In any
event, it shouldn't make any difference in being able to executing the code.

--
Regards,
Tom Ogilvy

"loopy " wrote in message
...
I have added the stop recording tool bar to get the relative reference
button.

whether I have the button selected or not, i get relative reverances in
the VB script when auto recording.

I need to turn of relative, and cant!

your help is appreciated


---
Message posted from http://www.ExcelForum.com/