formula based on another cell's formula

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
 
P

papou

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula in Excel 07 to get the formula used in one cell in anothercell, showing VALUES, not cells re 1
If Not blank - Formula for two cells 0
can a cell be both input and output? 3
Show a cell's formula in text format in a linked cell 2
Referencing the values of multiple cells in conditinal formatting. 0
Identifying formulas using a Validation rule 8
Function for summing or counting cells based on a specified fill color 3
Show value from one cell in another cell if today falls between a date range 5

Top