Hi,
I'm trying to change a cell value from negative to positive in VBA. I tried different variations, but can't seem to get the syntax right.
If Range("C24") < 0 Then
Range("C24") = (Cell.Value * -1)
Any help would be appreciated.
Hi,
I'm trying to change a cell value from negative to positive in VBA. I tried different variations, but can't seem to get the syntax right.
If Range("C24") < 0 Then
Range("C24") = (Cell.Value * -1)
Any help would be appreciated.
Range("C24") = Range("c24").Value * -1 works
In your code you have used Cell.Value, What is the address of the Cell???
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks