The code below is what I am trying to modify to insert a Data Validation, List, source is indirect to the next column back.
This formula I am intending to hit CTRL SHIFT Z and it will grab the current row, and write the formula .. the reason is I have (150+) to insert this data validation and I would like to click the cell, chit Ctrl Shift Z and then select the next row..
The problem is, I recorded the process using the Record Macro, and even *that* code errors.
The error it gives me a "Run-time error '1004': Application-defined or object-defined error"
Row = ActiveCell.Row Range("N" & ActiveCell.Row).Select With Selection.Validation .Delete .Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:=xlBetween, Formula1:="=INDIRECT(M" & Row & ")" .IgnoreBlank = True .InCellDropdown = True .InputTitle = "" .ErrorTitle = "" .InputMessage = "" .ErrorMessage = "" .ShowInput = True .ShowError = True End With