Advanced VBA help
$30-60 USD
Оплачується при отриманні
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
ID Проекту: #4479910