Obviously according to the explanation and its attachment :I want to put their numbers into one Column, but Debit should with with + sign and Credits with minus sign.
Sub Demo1() With Sheet1.Range("C7", Sheet1.Cells(Rows.Count, 4).End(xlUp)).Columns .Item(1).Value2 = .Parent.Evaluate(.Item(1).Address & "-" & .Item(2).Address) .Item(2).ClearContents End With End Sub
It seems like an obvious thing to say, but as it is correct code, and works for other people, please can you explain exactly how it doesn't work?New
I copied ad pasted it into a Module, but it does not work...
You can look up different functions on MSDN.The method in the macro is very neat, but I never would have come up with it. Is there a good place to find background information on this technique?
Hi Doug and thanks for your revert.Is there a good place to find background information on this technique?