Dare I 'suggest' that custom autocomplete, in FormulaEditor is the 
best 'one size fits all' solution then?

Example:

I could use a custom 'macro' so that when I write;

Pivot = 

the ForumlaEditor completes;

Pivot = Ref(H + L + C,-1)/3;

OR

Pivot = (H + L + C,-1)/3;

OR for dummies like me:

Pivot = (Ref(H,-1) + Ref(L,-1) + Ref(C,-1)/3;

Reply via email to