I have been using this code for Data Validation for some time, but now when I try to use it, it throws a Run Time Error '1004' Application-Defined or Object-Defined Error. How can I change this to make it work again. I am using Office 365.
.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _
xlBetween, Formula1:="=INDIRECT(" & Cur_Cell & ")"
I am pretty sure this is the part of the code causing the issue:
Formula1:="=INDIRECT(" & Cur_Cell & ")"
Thanks In Advance For Any Help...
.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _
xlBetween, Formula1:="=INDIRECT(" & Cur_Cell & ")"
I am pretty sure this is the part of the code causing the issue:
Formula1:="=INDIRECT(" & Cur_Cell & ")"
Thanks In Advance For Any Help...