Posted to microsoft.public.excel.programming

Stephen[_24_] Stephen[_24_] is offline

external usenet poster

Posts: 83

Formula Problem in macro

Hi Folks,

This seems strange to me... I have a formula which works fine...
=IF('Executive Phone List.xls'!A5="","",'Executive Phone List.xls'!A5)
but when I try to insert that via a macro I get an error.

Range("A5").Select
ActiveCell.FormulaR1C1 = "=IF('Executive Phone List.xls'!A5="","",'Executive
Phone List.xls'!A5)"

Produces:

#NAME?

TIA,

Steve

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 in Macro	[email protected]	Excel Discussion (Misc queries)	2	April 4th 07 09:49 PM
Excel: VB Macro programming problem with formula writing	d-cubed[_2_]	Excel Programming	2	February 1st 07 07:25 PM
Problem with Formula n VB Macro	Emily[_3_]	Excel Programming	10	June 12th 06 07:09 PM
Macro Formula Updating Problem	Tim	Excel Programming	0	June 8th 04 05:16 PM
Excel/macro Formula Problem!	nic17	Excel Programming	5	June 3rd 04 06:22 PM

All times are GMT +1. The time now is 08:59 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us