Ark68
Well-known Member
- Joined
- Mar 23, 2004
- Messages
- 4,564
- Office Version
- 365
- 2016
- Platform
- Windows
I am running into an error when I'm trying to apply a validation list to a cell based on the values of a named range (nr_crwlist).
The line in red breaks with an error: "Application-defined or object-defined error"
Thoughts?
Rich (BB code):
Set crwlist = ws_fmatemp.Range("CJ29:CJ" & rw - 1)
crwlist = crwlist
ThisWorkbook.Names.Add Name:="nm_crwlist", RefersTo:=crwlist
For f = 9 To 636
If ws_fmagui.Cells(f, 23).Interior.Color = RGB(221, 235, 247) Then
ws_fmagui.Cells(f, 26).Validation.Add Type:=xlValidateList, Formula1:="=nm_crwlist"
End If
Next f
The line in red breaks with an error: "Application-defined or object-defined error"
Thoughts?