Posted to microsoft.public.excel.programming

Jeff[_40_] Jeff[_40_] is offline

external usenet poster

Posts: 2

Using formula problem

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formula Problem	Lise	Excel Discussion (Misc queries)	3	July 21st 09 04:05 AM
If formula problem	mrsmmm1000	Excel Worksheet Functions	8	July 6th 08 08:52 PM
Formula Problem	JoeH	New Users to Excel	3	July 4th 07 08:07 PM
Formula problem	Computer geek	Excel Worksheet Functions	4	June 8th 07 08:01 PM
problem with formula	jpoltor	Excel Discussion (Misc queries)	2	March 19th 06 12:19 AM

All times are GMT +1. The time now is 11:35 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us