Problems with project export to excel

[Buster]

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.

I'm trying to copy text from the columns to the right of the cell for the
range B4:I4, using the repeat function inside of the lookup function such
that text in the character range from the letter Z to asci code 255.

When I type this out, the letter Z causes no problems if not enclosed by
quotation marks. However in order to function the Z must be enclosed in
qutation marks.

 

[JackD]

Buster,

Try one of the excel groups for this.

 

[wrf]

I discovered that I needed double quotes around the Z in order to set the Z
within quatation marks.

Jeff