Hi all,
I would like to evaluate a range by taking the sum of absolute values. I'm kind of new to VBA and am stumped. I can take the sum of a range by using:
x = Application.Sum(Selection)
but I can't seem to get it to work with absolute values.
Does anyone have any suggestions?
Thanks from "but it's a dry heat" Las Vegas.
I would like to evaluate a range by taking the sum of absolute values. I'm kind of new to VBA and am stumped. I can take the sum of a range by using:
x = Application.Sum(Selection)
but I can't seem to get it to work with absolute values.
Does anyone have any suggestions?
Thanks from "but it's a dry heat" Las Vegas.