Gaius Marius
2011-03-30, 04:27 PM
Hi there. I want to establish an abstract excell range in VBA. With the Manager Returns defined as RangeA, and the Index Return defined as RangeB, I want to have something like:
dim ExcessReturn as Range
For n = 1 to RangeCount
ExcessReturn(n) = RangeA(n) - RangeB(n)
next n
problem is, it doesn't work. Anybody has any idea?
dim ExcessReturn as Range
For n = 1 to RangeCount
ExcessReturn(n) = RangeA(n) - RangeB(n)
next n
problem is, it doesn't work. Anybody has any idea?