Recorder macro will not run

[rednessator]

I have a set of named ranges. In range A1:A2 two of these named ranges are listed. In range B1:B2 i want to make a drop down list, with a list dependent on what named range are specified in the cell to the left, either A1 or A2. I create the lists successfully, and record my actions using macro recorder. But afterwards my code will not run. If I delete the drop down lists I just created, and try to run the code from the macro recorder, I get the error below. Please help!

<code style="margin: 0px; padding: 0px; border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; white-space: inherit;">Sub asdf()


With Range("B1:B2").Validation
.Delete
.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _
xlBetween, Formula1:="=INDIRECT(INDIRECT(""RC[-1]"",0))"
.IgnoreBlank = True
.InCellDropdown = True
.InputTitle = ""
.ErrorTitle = ""
.InputMessage = ""
.ErrorMessage = ""
.ShowInput = True
.ShowError = True
End With

End Sub</code>Problem is this gives me the error

Run time error 1004' (Application defined or object defined error)
​

and when I click debug the following line is highlighted
<code style="margin: 0px; padding: 0px; border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; white-space: inherit;"> .Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _
xlBetween, Formula1:="=INDIRECT(INDIRECT(""RC[-1]"",0))"</code>

 

[rednessator]

It is some problem with using INDIRECT...

 

[rednessator]

anybody, please?