Paste as absolute Value

Have you looked at this:
http://www.mrexcel.com/forum/excel-q...-can-done.html

Hi Andrew87..
Something like this ?

Please Login or Register  to view this content.

Alan

EDIT: What is SAP ?

Hi Andrew87..
Sorry, I do not quite follow you?
I do not quite understand what you are trying to do?
I have not changed the value or format in any cell. I just put the -6391 in an arbitrary cell to demo.

My strABS is what you would pass to whatever it is that wants the Absolute value of what is in a cell

I expect i have just not quite grasped exactly what you are trying to do, sorry

Alan

Hi Andrew87..
Just another demo:
60 I copy from one cell
and
70 I paste to the adjacent one ( I maintain all Formats )

Then I

90 overwrite the Value only in the Cell that i am pasting to with the absolute Value from the original Cell, whose format and Value remains as it was

Please Login or Register  to view this content.

_............................


or you just want

Please Login or Register  to view this content.

or you just want line 90 on its own



Possibly the confusion is arising as you are using the word Paste. Maybe you are saying that you want to pass the absolute value of a cell to something. Or in English , you want to give the absolute value from a cell to something.
The word Paste tends to suggest the various Paste or Paste Special operations in VBA , which might send a VBA person off in the wrong direction of thinking. I expect that is what happened initially with Glenn


Alan

I could obviously use a helper column, but I am just wondering if there is any proper solution.

As one who looks at this question and says to himself that a helper column with the =ABS() function in it is the most obvious easy solution, I would wonder why the use of such a helper column is not considered a "proper" solution. The code given in the OP then seems like it would work without modification (except for changing the column being referenced). It seems to me like we are going to a lot of unnecessary work to avoid using the helper column.

But that's just me.

I am a great fan of helper columns. Especially with Formulas. I would rather break a long complicated formula down into helper columns. I find both understanding and Debugging better then. The helper columns can be anywhere, even in a another Worksheet. I like that Approach. In the main Worksheet I just have the last Formula and keep everything tidy. The in the helper Worksheet I can see everything.
Working on the helper Worksheet is then like taking the back off an old television to get at all the workings to repair or modify it, rather than havig everything compressed in a small chip in a modern television that you can do nothing esilly with.


In the OP's case, if I have sussed out what he wants , then he just "takes"
Replace(ThisWorkbook.Worksheets("Sheet1").Range("C" & row).Value, "-", "", 1, 1)
instead of
ThisWorkbook.Worksheets("Sheet1").Range("C" & row).Value
So maybe no helper column is needed
Alan

You is welcome
Thanks for the feedback
Alan

EDIT: Thanks for the Rep.....
- Remember " take " " or " write in " the Value, not " Paste " the Value