Error when running macro containing data validation dropdown lists

[Karlbirger]

Hi guys

Im using vista + excel 2007 for the record.

Current macro receives debug (bolded and colored text) when I run it:

Range("J6").Select
    With Selection.Validation
        .Delete
[B][COLOR="Red"]        .Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _
        xlBetween, Formula1:="=INDIRECT(I6)"[/COLOR][/B]
        .IgnoreBlank = True
        .InCellDropdown = True
        .InputTitle = ""
        .ErrorTitle = ""
        .InputMessage = ""
        .ErrorMessage = ""
        .ShowInput = True
        .ShowError = True
    End With

I don't understand why. I use the common code "=INDIRECT(I6)", which in this case contains 3 different options in cell I6, nothing strange with them.

I can create this validation dropdown list manually and receive no error messages, which makes things ever more strange imo.

Grateful for any help/input.

Regards
Johan