Hi all,

i was unable to find the answer I need so I'm kindly turning for experts' help.

I simply need copy and paste a negative value as ABS value. if I have -6391 , it would be pasted as 6391. I have tried to look for workaround such as copying all characters behind minus, but haven't managed it.

Range("C" & row).Select
    Selection.Copy
Session.findById("wnd[0]/usr/txtBSEG-WRBTR").Text = ThisWorkbook.Sheets("Sheet1").Range("C" & row).Value
I cannot change all values to absolute as I need it visible in the worksheet. I could obviously use a helper column, but I am just wondering if there is any proper solution.

Many thanks!