xlApp.Range("A4").Formula =
"=LOOKUP(REPT("Z",255),B4:I4)"

??

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Jeff" wrote in message
m...
I am trying to use the following in Excel VBA;
xlApp.Selection.Range("A4", code).Formula =
"=LOOKUP(REPT("Z",255),B4:I4)"

If I leave off the formula portion the .formula expression is fine.
The problem I'm having is that I keep getting "Compile Error
Expected:)" But I have all of my brackets balanced.

Jeff