Offset References When Recording Macros

[Rabk]

Thank all of you for the insights I've already gotten from these forums; they've been a real help. I'm relatively new to VBACode, mostly having learned so far by recording macros and then taking the code apart line by line, so I apologize in advance for any inane or seemingly obvious questions I may ask in the future.

Here's the first of what I'm sure will be many:

When I'm recording a macro and I write a formula that references another worksheet, the VBACode automatically writes it as an offset from the current cell. (Not sure what to call the reference style-- VBA Help is not as erm, helpful as it could be on this point.)

Example:

Please Login or Register  to view this content.

What setting do I need to change to make it automatically record references to other worksheets as an "a1" style reference?

[royUK]

see this
http://www.excel-it.com/record_macro.htm

[Rabk]

Thank you very much for the reply, but I'm not sure that's what I needed. The link told me how to force a reference to be absolute or relative but not how to force it to appear in the code as an A1-style reference.

Currently it records as:

Please Login or Register  to view this content.

I need it to record as:

Please Login or Register  to view this content.