I have gotten my drop down lists to work through vba. I now need a drop down list that is dependant on what was chosen from the first drop down list. I know you use the =INDIRECT(A1) when setting this up manually. I've tried to do this same thing through vba. But I seem to get an error. This is what I have in my vba code:

With Range("A:A").Validation
.Delete
.Add xlValidateList, xlValidAlertStop, xlBetween, "=Catalog"
.InCellDropdown = True
.ErrorMessage = "You must chose from the list of possible choices."
End With

With Range("B:B").Validation
.Delete
.Add xlValidateList, xlValidAlertStop, xlBetween, "=INDIRECT(A1)"
.InCellDropdown = True
.ErrorMessage = "You must chose from the list of possible choices."
End With

Does anyone have any thoughts. It' bombs out on the second with range (b:b) on the .add xlvalidatelist, xlValidAlertStop, xlBetween, "=INDIRECT(A1). And I'm not sure why.

Thanks in advance