Ahojte,
>> =MID(FORMULA(B1);2;LEN(FORMULA(B1))-1)
>
> Ano, ano, to je ono, diik, len este keby to v tom exceli
> islo ;(
> --
> DuRo/piXie
V Excelu bohuzel chybi funkce formula, ale muzete si nadefinovat
uzivatelskou fci.
Nejjednoduzsi postup je:
-Tools->Macro->Record New Macro...
-vyplnit: Macro Name: FORMULA a zmacknout tlacitko [OK]
-zastavit nahravani makra
-spustit VBA editor pres Alt-F11
-nahradit kod v Module1:
puvodni kod:
Sub FORMULA()
End Sub
novy kod:
Function FORMULA(CellRef As Range) As String
FORMULA = CellRef.FORMULA
End Function
-ulozit a vyzkouset :-))
Problem s excelem je, ze jsou tam prelozene jmena funkci, takze kdyz tu
mam nemeckou verzi, tak jsem namisto
=RIGHT(FORMULA(B5),LEN(FORMULA(B5))-1)
musel volat:
=RECHTS(FORMULA(B5);LÄNGE(FORMULA(B5))-1)
Caute,
pepa cacek
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
