Norman,

I used Excel's validation and it works fine until a new row is added and the
validation moves down. My spreadsheet has a routine wich adds a new data row
at row3 for the new entry. The validation moves with the old row 3 to row 4
vwith the old data. The routine also specifies row 3 after the row addition
as follows:

Range("E3").Select
With Selection.Validation
.Delete
.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _
xlBetween, Formula1:="=transtype"
.IgnoreBlank = True
.InCellDropdown = True
.InputTitle = ""
.ErrorTitle = "Invalid Data"
.InputMessage = ""
.ErrorMessage = "You must choose from the drop-down list."
.ShowInput = True
.ShowError = True
End With

It is not working and I am stymied as to what is wrong. Can you help?

Thanks,

Jim
--
Pops Jackson


"Norman Jones" wrote:

Hi AD108,

even code == event code

---
Regards,
Norman