Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Runtime error 438
I am getting a runtime error 438 at the line between asterisks - can anyone
tell me why? For Each MyCell In Range("C71:K71") If MyCell.Value = vbNullString Then With MyCell.Offset(1) .Validation.Delete .Value = vbNullString .Locked = True End With With MyCell.Offset(2) .Validation.Delete .Value = vbNullString .Locked = True End With ElseIf MyCell.Value < "" Then With MyCell.Offset(1) .Locked = False With .Validation .Delete .Add Type:=xlValidateList, Formula1:="Boundary,Lost Ball,Water,Unplay,Other" .IgnoreBlank = True .InCellDropdown = True End With End With End If If MyCell.Offset(1).Value = vbNullString Then With MyCell.Offset(2) .Validation.Delete .Value = vbNullString .Locked = True End With ElseIf MyCell.Offset(1).Value < "" Then With MyCell.Offset(2) .Locked = False .Validation.Delete ******* .Add Type:=xlValidateList, Formula1:="Boundary,Lost Ball,Water,Unplay,Other" ******* .IgnoreBlank = True .InCellDropdown = True End With End If Next MyCell Thanks Sandy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
runtime error '1004' application or object defined error | Excel Programming | |||
runtime error 13 - type mismatch error in Excel 97 on Citrix | Excel Programming | |||
runtime error '1004' application or object defined error. Please help | Excel Programming | |||
Excel 2003 Macro Error - Runtime error 1004 | Excel Discussion (Misc queries) | |||
Syntax Error Runtime Error '424' Object Required | Excel Programming |