I know I want to be using A1:A500, but I'm trying to calculate for like
20 different ranges as well, it keeps changing the A1 value to A2, A3,
A4 etc...
I don't know how to stop that without re-writing the whole thing


--
Ender
------------------------------------------------------------------------
Ender's Profile: http://www.excelforum.com/member.php...o&userid=33258
View this thread: http://www.excelforum.com/showthread...hreadid=530810