Try something similar to this in a Worksheet Change event:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$B$10" Then FindCRN
End Sub


--
Damon Longworth

Don't miss out on the 2005 Excel User Conference
Sept 16th and 17th
Stockyards Hotel - Ft. Worth, Texas
www.ExcelUserConference.com


"Ken Loomis" wrote in message
...
I am trying to call a sub whenever a single cell of a worksheet is changed.
I know how to do that whenever ANY cell on a worksheet is changed, but is
there a way to only call the sub when a SPECIFIC cell is changed.

For example, is cell 'b10" (labeled CRN) is changed, I want to call a sub,
on the same worksheet, called "FindCRN".

Can anyone give me any suggestions?

TIA,
Ken