conditional formatting

[geebee]

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]

Is that a space after the "D"?

--
Jim
| 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
|