montecarlo2012
Well-known Member
- Joined
- Jan 26, 2011
- Messages
- 984
- Office Version
- 2010
- Platform
- Windows
Hi, so far this little code work, but when I tried to used with ABS[....] then whatever I did, is not working
Please if you can show me a loop for this would be good, and I am looking for the absolute value.
thanks.
VBA Code:
Sub d()
[AB2:AB8909] = [B2:B8909 -AB1]
[AC2:AC8909] = [C2:C8909 - AC1]
[AD2:AD8909] = [D2:D8909 - AD1]
[AE2:AE8909] = [E2:E8909 - AE1]
[AF2:AF8909] = [F2:F8909 - AF1]
End Sub
thanks.