Quick question,
I have a variable assigned as a Public integer:

Public NIG As Integer

which is assigned as an input from the user:

NIG = InputBox("Please enter the Non Investment Grade limit for filter(deafult BBB-)", "NIG Limit", 610)

I wish to use this in a logic argument:

ActiveCell.FormulaR1C1 = _
"=COUNTIF(Portfolio!R[-28]C[5]:R[591]C[5]," >= " & NIG &)/COUNT(Portfolio!R[-28]C[5]:R[591]C[5])%"

But this is returning a "TRUE" - I was expecting a percentile figure!

Any ideas?

Cheers.