View Full Version : VBA - Ranges?

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?