colors and countif follow

[nyn04]

two issues, this in regrad to an earlier post today..

MsgBox WorksheetFunction(Range("TradesDiff"), "<0")

I run this and I get nothing

any ideas

my variable is defined as

Dim tradesDiff ()]

m = 300

Redim (m)
I am new to vba, when I put the values in excel cells I can then ru
the countif on the excel sheet but I need to avoid that, my values ru
from 17 to 40

2. how will I set backround and letter colors from vba to a cell

thank yo

 

[Bob Phillips]

First point - see my response to previous question.

Second point

Cells(1,4).Interior.ColorIndex = 3

Cells(1,4).Font.Colorindex = 3

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)