B
Bill
Lisa,
I am unsure what you are asking exactly about the offset.
But you can shift your current selection using offset, for
example, if range "A1:C10" is currently selected you can
shift or move your current selection to "F6:H15" using the
following:
Selection.Offset(5, 5).Select
As far as recording a macro using relative references, I
guess you already know you can turn it off manually: after
you turn on the recorder, the on/off relative references
button appears on the "Stop Recording" toolbar. I don't
think there is a way to set a particular default on it.
I am unsure what you are asking exactly about the offset.
But you can shift your current selection using offset, for
example, if range "A1:C10" is currently selected you can
shift or move your current selection to "F6:H15" using the
following:
Selection.Offset(5, 5).Select
As far as recording a macro using relative references, I
guess you already know you can turn it off manually: after
you turn on the recorder, the on/off relative references
button appears on the "Stop Recording" toolbar. I don't
think there is a way to set a particular default on it.