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:
ActiveCell.FormulaR1C1 = "=MAX(Blender!R[-3]C[-3]:R[152]C[-3])"
What setting do I need to change to make it automatically record references to other worksheets as an "a1" style reference?
Bookmarks