Stephen,

Yes I did. I had a 5 cell LamTable, and I applied a DV list of a,b,c,<none.

DV does not trigger a change event in XL97. Which version do you have?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"ned" <pcompNOSPAMatCanada.com wrote in message
...
Bob;

Thanks for the reply. It works for me until I add the Data Validation on
the Range "LamTable". After that it fails when I try to change any cell
on
the sheet. Did you apply data validation to limit cells in LamTable to a
list?

Thanks,

Stephen

"Bob Phillips" wrote in message
...
Stephen,

I just plugged the code into my worksheet and it worked fine for me.
XL2000,
XP Pro.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)