invalid procedure call

[geebee]

hi,

i have the following:

selection.formatconditions.add type:=xlformula, operator:=xllesequal, _
formula1:=round(" & xlcol2 & "17,3)<=$G$17"

and this is causing a runtime error 5: invalid procedure call or argument.

how can i fix this?

thanks in advance,
geebee

 

[Chip Pearson]

Try

Selection.FormatConditions.Delete
Selection.FormatConditions.Add Type:=xlExpression, _
Formula1:="=round(" & xlcol2 & "17,3)<=$G$17"


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)