This'll do it:

range(activecell, activecell.end(xldown).offset(-1,0)).filldown


Col


--
colofnature
------------------------------------------------------------------------
colofnature's Profile: http://www.excelforum.com/member.php...o&userid=34356
View this thread: http://www.excelforum.com/showthread...hreadid=560728