Advanced VBA help

Problem: I have programmed an add-in to Excel in VBA, which can show you the formula and expression. First a description: We state an example: A1 = 2, B1=2 And we want to sum this terms in C1, such that: =A1+B1 =4 Then I have made 2 options: 1. Default: So, if you mark cell C1: and push expression og formula you will get the formula/expression in D1. 2. Fixed column: Then you can mark C1: push expression and formula and you can choose which cell you want the result. What my currently code cannot do, and what my problem is: if I hold let say: $A$1 and muliply it with B2 and want the result in C1. Yes I still get 4, but the expression neither formula cannot show 2*2 or A1+B1. Instead it shows respectivly $A$1+2 and $A$1+$B$1. In other words my code for expression and formula is not closed under absolutereference. I need one who can give the last touch to this code so it wil work. You can deal with it in the added Xlam file, and see a picture of the problem