I have a value that I moved from another worksheet and it is negative, but I need it to be positive. How do I do that?
After you’ve read the data (in this example into variable
MyVar of type String), you can convert it with
can you show me what you mean?
You can use exactly the code I’ve posted, as long as you’ve read the data into a variable. To get the data, you’ll need to use read range before setting the variable and to write the data, you’ll need to use write range.