I am using EXCEL 97.

I have used the following:

Private Sub Worksheet_Change(ByVal Target As Excel.Range)

But I am getting a debug prompt regularly.

I want monitor changes to only a range of B9:AC13.

Is there a way to set it so that it only monitors this part and if so can
anyone assist me please?


--
Mark