hi debra, had another question if you're still lurking =D the code:

Select Case Target.Column
Case 2, 3, 4, 5, 6

specifies columns with validation cell. if i had numerous columns could i
use something like:
Case 2 to 50

and what if i wanted to make it open ended, or any column in the sheet?


"Debra Dalgleish" wrote:

You're welcome, and thanks for letting me know how you changed the macro
to suit your workbook.