View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Rech[_2_] Jim Rech[_2_] is offline
external usenet poster
 
Posts: 533
Default conditional formatting

Is that a space after the "D"?

--
Jim
"geebee" (noSPAMs) wrote in message
...
| hi,
|
| i have the following:
|
| dim z as integer
| for z = 8 to 100
|
| Selection.FormatConditions.Add Type:=xlExpression, Formula1:= _
| "=ROUND(D " & z & ",3)=$B$5"
|
| next z
|
| for some reason i am getting a runtime error 5 error message: invalid
| procedure call or argument. im not sure why.
|
| thanks in advance,
| geebee
|