In Col "K" I have Extended Sales.
In Col "M" I have Qty Shipped.
When the $ in "M" is a negative,
I need to turn the number in "M" negative.
Here's Coding I used:
'The DIM code that follows Formats "O", "P", & "R".
Dim lastrow As Long
Dim UsedRng As Range, UsedCell As Range
With ActiveSheet
.UsedRange 'Resets the range (so I'm told)
'The NExt Line Formats "M".
.Range("M2:M" & lastrow) = "=IF(RC[-2]<0,RC*-1,RC)"
End With
End Sub
Result: All data in "M" turns to 0.
and the Cell contents in M2 now reads =IF(K2<0,M2*-1,M2) !!!!!!!!!!!
Anyone have a clue where I goofed?
ZAc
In Col "M" I have Qty Shipped.
When the $ in "M" is a negative,
I need to turn the number in "M" negative.
Here's Coding I used:
'The DIM code that follows Formats "O", "P", & "R".
Dim lastrow As Long
Dim UsedRng As Range, UsedCell As Range
With ActiveSheet
.UsedRange 'Resets the range (so I'm told)
'The NExt Line Formats "M".
.Range("M2:M" & lastrow) = "=IF(RC[-2]<0,RC*-1,RC)"
End With
End Sub
Result: All data in "M" turns to 0.
and the Cell contents in M2 now reads =IF(K2<0,M2*-1,M2) !!!!!!!!!!!
Anyone have a clue where I goofed?
ZAc