Thread: Copy Data Validation

XL2k....I have Data Validation in several (not all) cells from A1:J1.

When I change the value, or insert one, in any cell down column A, I would
like all that Data Validation information to be copied from row 1 down to the
activerow, without changing any values in the activerow. I can do it by
hand, but dont' seem to be able to get there with code. Any help would be
apprecaited.

Vaya con Dios,
Chuck, CABGx3

Hi Chuck

You should check out the Worksheet_Change event.

This event needs to reside within the individual worksheet in question. This will give you the base event to copy the validation down to the active row. Please look around on good for a better example or for a way to copy the validation etc. An example of the parent routine is shown below.

Private Sub Worksheet_Change(ByVal Target As Range)

MsgBox "You have just changed " & Target.Address

End Sub
Hope that helps.