"Joe User" <joeu2004 wrote in message
...
"Bob Phillips" wrote:


But I don't find the relative reference very practical for RK's purpose,
namely to use in a formula unless you deviate from Biff's instructions.
For example, selecting B1 and defining the named formula =GET.CELL(48,A1)
permits us to apply the named formula to any cell to the left.

It isn't as I pointed out earlier. My XLM macro is far better ... but


Perhaps Lori's approach is more flexible. I haven't tried it.

It is, it is sheer brilliance.