Validation Error

[ranswert]

I get a "Can't execute code in break mode" when i run the code below:

xcell.Offset(0, 2).Validation
With Validation
.Delete
.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _
xlBetween, Formula1:="=$AB$6:$AB$27"
.IgnoreBlank = True
.InCellDropdown = True
.InputTitle = ""
.ErrorTitle = ""
.InputMessage = ""
.ErrorMessage = ""
.ShowInput = False
.ShowError = True
End With

What am I doing wrong?
Thanks

 

[Joel]

Nothing! You just can't put break point around certain lines of code.

 

[Nigel]

With xcell.Offset(0, 2).Validation


--

Regards,
Nigel
(e-mail address removed)

 

[ranswert]

How do I need to write this so that it will work?

 

[ranswert]

That Worked
Thanks

With xcell.Offset(0, 2).Validation


--

Regards,
Nigel
(e-mail address removed)