How do I create a Macro that creates a formula in a cell instead of just
inputting a value?

Suppose I want to add two cells:

1.) C:\Documents and
Settings\pgalla06\Desktop\Company\[Wolf.xls]Other Coverages'!$G$7

and

2.) Y4

So that the formula in the cell reads:

=C:\Documents and Settings\pgalla06\Desktop\Company\[Wolf.xls]Other
Coverages'!$G$7+Y4

I only know how to create macro that inputs a value in the cell not a
formula. Any help is greatly appreciated.

Thanks,
PEter


--
PGalla06
------------------------------------------------------------------------
PGalla06's Profile: http://www.excelforum.com/member.php...o&userid=24260
View this thread: http://www.excelforum.com/showthread...hreadid=379509

Just put quotes around your formula as you would put it directly into
worksheet cell.

Range("A1") = "=C:\Documents an
Settings\pgalla06\Desktop\Company\[Wolf.xls]Other Coverages'!$G$7+Y4"

Substitute the destination cell for A1 in the range assignment

HT

--
bhofset
-----------------------------------------------------------------------
bhofsetz's Profile: http://www.excelforum.com/member.php...fo&userid=1880
View this thread: http://www.excelforum.com/showthread.php?threadid=37950