Hello,
I have the following sub within a larger macro.
Some users, but not all, get a 1004 error on
When the users gets that error I can end the sub then enter the formula into data validation and it work just fine.
Halp!!!
I have the following sub within a larger macro.
Code:
Sub ValidateData()
'Insert Data Validation
Sheets("Open Orders").Select
Range("E3:E65536").Select
With Selection.Validation
.Delete
.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _
xlBetween, Formula1:= _
"=OFFSET('Inventory Qry'!$A$1,MATCH(C3,'Inventory Qry'!$A:$A,0)-1,1,COUNTIF('Inventory Qry'!$A:$A,C3),1)"
.IgnoreBlank = True
.InCellDropdown = True
.InputTitle = ""
.ErrorTitle = ""
.InputMessage = ""
.ErrorMessage = ""
.ShowInput = True
.ShowError = True
End With
Range("A1").Select
End Sub
Some users, but not all, get a 1004 error on
Code:
.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _
xlBetween, Formula1:= _
"=OFFSET('Inventory Qry'!$A$1,MATCH(C3,'Inventory Qry'!$A:$A,0)-1,1,COUNTIF('Inventory Qry'!$A:$A,C3),1)"
When the users gets that error I can end the sub then enter the formula into data validation and it work just fine.
Halp!!!