Extract Cell Address From Formula

[nigelk]

Hi all,

Is it possible to extract the cell addresses from formulas?

I'm currently storing the formula as a string, for example:

Dim Strng As String

Strng = Range("B2").Formula

MsgBox Strng

which returns "=A2+A3".

I would like to get the value of those two cells as well. A2 could equal 5 and A3 could equal 2, or vice versa, but I would like to know what value was in what cell at the time.

Thanks,Nigel

 

[wigi]

Hello

Have a look here: http://www.ozgrid.com/forum/showthread.php?t=154824

Wigi

 

[nigelk]

Thanks, works a treat.

Nigel.