The value in the cell is invalid... put the code in debug mode and step through until you reach the error..

What is the cell's value??