have a button which loops thru the grade column, if the cellvalue
evaluates to not fail then populate an array.

When the grade column has been evaluated, goto WS2 and populate with
the array!


--
MattShoreson
------------------------------------------------------------------------
MattShoreson's Profile: http://www.excelforum.com/member.php...fo&userid=3472
View this thread: http://www.excelforum.com/showthread...hreadid=495306