Posted to microsoft.public.excel.programming

external usenet poster

Posts: 161

formuls

I need to write a code that inserts a formula into a cell.
The code is:

Range("est0" & i).FormulaR1C1 = _
"=('Estimate Costs'!R[i]C[7]&"" ""&'Estimate Costs'!R[i]C[8])"

The row needs to increment 'i' down each time I insert the formula.

I get an error when it is run. I have i as an integer.

What am I doing wrong?
Thanks

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
Inserting date from formuls	TechGuy[_2_]	Excel Discussion (Misc queries)	1	February 3rd 10 09:30 PM
Fill formuls plus one	Jasmine	Excel Programming	1	June 29th 06 10:50 PM
Formating Font in a Formuls	Silvanus	New Users to Excel	5	December 9th 05 03:22 PM
Formuls updating	Adam	Excel Worksheet Functions	2	October 19th 05 07:49 PM
how do I do a formuls in excel such as (if a1=somthing then b1=a .	Brett	Excel Worksheet Functions	3	January 9th 05 08:15 PM

All times are GMT +1. The time now is 10:20 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us