Posted to microsoft.public.excel.programming

Archie[_6_] Archie[_6_] is offline

external usenet poster

Posts: 4

Fill formula from VBA

Hi,

I try to enter a formula in a cell using VBA: =VLOOKUP($L2;'Sheet
2'!$A$2:$D$6000;2;FALSE)
This fails with a Run-time error '1004'
Entering this formula by hand works OK

When I remove the reference to 'Sheet 2' it all works OK:
=VLOOKUP($L2;$A$2:$D$6000;2;FALSE)

It looks like a bug to me (or a feature?)

How can I insert this formula refering to another sheet in a cell using VBA?

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
Fill Formula please	palups	Excel Worksheet Functions	5	November 12th 09 08:27 AM
formula fill down	Pezcore	Excel Discussion (Misc queries)	4	May 10th 08 06:17 PM
Formula Fill help	Josh O.	Excel Worksheet Functions	1	May 12th 06 09:46 PM
Fill Down formula Help Please	singlgl1	Excel Discussion (Misc queries)	6	October 24th 05 08:22 PM
Help with formula fill down	comotoman	Excel Discussion (Misc queries)	4	October 3rd 05 09:46 PM

All times are GMT +1. The time now is 06:57 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us