I think this is what you want
activecell.CurrentRegion.selec
--
duan
-----------------------------------------------------------------------
duane's Profile:
http://www.excelforum.com/member.php...fo&userid=1162
View this thread:
http://www.excelforum.com/showthread.php?threadid=26595