thanks for the reply, tom. i guess i'll still have to clear the cells, but your tip has been helpful. i never knew that you can do that with ranges. i learn something new every day!

cheers!