Sub chagneme()
![]()
With ActiveSheet For Each cel In .Range("C1", .Range("C" & .Rows.Count).End(xlUp)) If Len(cel) Then cel.Value = Val(cel.Value) * -1 End If Next End With End Sub
Sub chagneme()
![]()
With ActiveSheet For Each cel In .Range("C1", .Range("C" & .Rows.Count).End(xlUp)) If Len(cel) Then cel.Value = Val(cel.Value) * -1 End If Next End With End Sub
Last edited by AB33; 08-12-2013 at 11:00 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks