Osvaldo Palmeiro
Well-known Member
- Joined
- Feb 24, 2009
- Messages
- 753
- Office Version
- 365
- Platform
- Windows
Hello all.
I can get the modify sintaxe correctly to AppliesToRange as below but I can't get to ModifyFormula1.
Many thanks in advance for any help
I can get the modify sintaxe correctly to AppliesToRange as below but I can't get to ModifyFormula1.
Code:
Sub CFTest
ActiveCell.FormatConditions(1).ModifyAppliesToRange Range("$L$2:$L$115") 'this works properly
ActiveCell.FormatConditions(1).ModifyFormula1 "=$I2=1" 'this doesn't work _
object doesn't support this property or method
End Sub
Many thanks in advance for any help
Last edited: