Does anyone know a common cause of/solution to the Select Method of
Range Object failing. I'm running this code during the deactivat
subfunction:

cRow = Range("$A:$A").Cells(Rows.Count, 1).End(xlUp).Row
Range(Cells(2, 1), Cells(cRow, 2)).Select

This code worked last week, but this week it has decided to break.

Cheers-
Chris Krah

--
cmk1
-----------------------------------------------------------------------
cmk18's Profile: http://www.excelforum.com/member.php...nfo&userid=604
View this thread: http://www.excelforum.com/showthread.php?threadid=38624