Get Column Reference from Formula (Linked Cell)

[Biz]

Hi,

In Variance tab in cell C4 I have formula ='Forecast vs Budget'!AC8.

Is the VBA/UDF or formula that can extract cell J4 AC?


Biz

 

[xld]

MyCell = Right$(Len(Range("C4")), Instr(Range("C4").Value,"!"))

 

[Biz]

Thank you for your help.