Chaim: Did you mean to set your validation list range as j11:j13? Or
should it be j1:j13? ($J:1$J13)

Ed

"haim rozent" wrote in message
...

hi !
I apriciate your help about validate list.
I creat a macro to build a validate list, but
when I open this validate List it dos'nt start on
the top but in the middle and I have to move the ligule up
every time I open it
how can I change this situation

this is the macro

Sub Add_Validate_List()
ActiveCell.Select
With Selection.Validation
.Delete
.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop,
Operator:= _
xlBetween, Formula1:="=$J$11:$J$13"
.IgnoreBlank = True
.InCellDropdown = True
.InputTitle = ""
.ErrorTitle = ""
.InputMessage = ""
.ErrorMessage = ""
.ShowInput = True
.ShowError = True
End With
End Sub

can you help me whithin the macro or whatever ?

thank you
chaim rozent

fax 972-4-8776654



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!