Leave $M absolute
In A1: "=$M3"
In A2: "=$M6"
In B1: "=$M4"
In B2: "=$M7"
In C1: "=$M5"
In C2: "=$M8"
Select A1:C2 and drag down, select Fll series if Excel dowsn't do it
automatically.
--
Garry
Free usenet access at
http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.
vb.general.discussion