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
Jim Rech - 31 Mar 2008 19:00 GMT
Is that a space after the "D"?

Signature
Jim
| hi,
|
[quoted text clipped - 13 lines]
| thanks in advance,
| geebee