Relative Macro Button

[berg891832]

Can someone give me a good example of when to use the Relative button on the macro toolbar.

I have messed with it and I can see sort of what it does, but I can't find a good example.

bill

 

[Fryer Tuck]

If you have a repetitive task (such as copy a cell to some other cell) that you want to make into a macro, use the relative so that the actions take place relative to the active cell, rather than the action occuring in the same cells each time you start the macro.

F.T.