Hello Norman,

Thanks for your quick response. Still fighting this.

My data falls in F92:Q235
"Original Booked" indicator is in column B. So how do I change the rng
to match this?? Is this the only thing that needs to be changed so that
if I try to add or change a value in the row which contains "Original
Booked" in column "B", it would give me a msg saying NO...

Set rng = Intersect(Me.Range("C5:H7"), Target)
Set rng2 = Intersect(Me.Range("F92:Q235"), Target)

Thanks,
Matt


--
matt4003
------------------------------------------------------------------------
matt4003's Profile: http://www.excelforum.com/member.php...fo&userid=9635
View this thread: http://www.excelforum.com/showthread...hreadid=508707