formula based on another cell's formula

  • Thread starter Thread starter sphenisc
  • Start date Start date
S

sphenisc

Hi, I'd like to extract info from another cell's formula
is this possible?

e.g.

a1: ='IT sheet'!A$3

b1: = mid(getformula(A1),4,2)

b1 would show 'IT'.

Is there something that would do the getformula bit.

cheers
 
Hi
Function AfficheLaFormule(LaCel As Range)
If LaCel.HasFormula = False Then
AfficheLaFormule = False
Else: AfficheLaFormule = LaCel.Formula
End If
End Function

b1: = mid(AfficheLaFormule(A1),4,2)

HTH
Cordially
Pascal
 
Back
Top