Posted to microsoft.public.excel.programming

Jasmine

external usenet poster

Posts: 27

Fill formuls plus one

I am using the following to put a formula in the first cell and copy it down
to the other cells. It is working good, but I need it to copy one cell
further than it does. Any way to force it?

Range("E2:E" & Range("D65536").End(xlUp).Row).FormulaR1C1 = _
"=IF(RC[-1]0,TODAY()-(RC[-1]+30),"" "")"

Thank you very much!

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
Formuls to turn date red	John M.	Excel Discussion (Misc queries)	1	January 27th 07 06:02 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:02 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us