invalid procedure call

  • Thread starter Thread starter geebee
  • Start date Start date
G

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
 
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)
 
Back
Top