conditional formatting
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 |
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 | |
All times are GMT +1. The time now is 01:37 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com