Excel Formulas Treated as Strings

C

cjes

I am trying to create a formula through code.

I am managing to do this but in the actual cell the formula is not being
calculated. It is being treated as text.
Ex.
In cell B1 i have a value of 500
I want to create a formula showing 500 *5 in cell b2.

in cell b2 I am calling a function ChgVal(B1). The result in B2 is correctly
showing =500*5 but it is not showing the value 2500.
I also tried using the VALUE command but to no avail.
Can anyone pls help?
Thanks
 

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

VBA Coding Help for Beginner 0
If Condition 0
Concatenate when pasting. 0
If Condition 4
Can a formula do this? 1
Drop down list control value in vba 2
Cause and Effect chart convertion 0
Extracting a Part of a Formula as Text 5

Top