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