I'm fumbling through this thinking maybe it will help me in what I'm
trying to accomplish but for some reason the following lines are red in
my VB Editor

y = worksheetfunction.Countif(Range("A1:A" & x)

If y 1 And len(cells(x-y + 1,3) = 0 then

Any ideas?


--
DKY
------------------------------------------------------------------------
DKY's Profile: http://www.excelforum.com/member.php...o&userid=14515
View this thread: http://www.excelforum.com/showthread...hreadid=474833