As a test put some values in the empty cells and try your code. It
should work.

Once you have established the problem is empty cells you can experiment
by populating the first empty cell and seeing if the code still works.

Then you need to update your code to check the status of empty cells and
put something in them temporarily so your code runs. Then clear those
cells when finished.

Cheers
Andy

ramkumar_cpt wrote:
Yes Andy. My cell has contains no value. it is empty. so what?



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info