If Not Intersect(Target, Range("CRN")) Is Nothing Then FindCRN


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Ken Loomis" wrote in message
...
Thanks, Damon. That works well.

I am still laying out the user input worksheet, so I was hoping I could
change this:

If Target.Address = "$B$10" Then FindCRN

to

If Target.Address = "CRN" Then FindCRN

since 'CRN' is the label for that cell.

I tried that but it doesn't work. Is there a way to change that statement
to
test to see if the call labeled "CRN" has been changed?

Or, will I just need to update the "$B$10" whenever I add rows or columns
to
the finished spreadsheet.?

Ken
"Damon Longworth" wrote in message
...
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