Posted to microsoft.public.excel.programming

Quietman

external usenet poster

Posts: 109

FormulaR1C1 Help

Range("Temp_Col").FormulaR1C1 = "=-SUMIF(" & DataArray & ",RC1,OFFSET(" &
DataArray & ",0,R1C,ROWS(" & DataArray & "),1))"

Does anyone know how/if I can get this formula results as a value not the
actual formula, so I do not have to copy paste special values the range
afterwards?

Thanks in advance

--
Helping Is always a good thing

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
What Does FormulaR1C1 Do?	Bob Phillips	Excel Programming	0	December 14th 06 11:39 PM
FormulaR1C1	Aksel Børve	Excel Programming	2	February 28th 05 09:52 PM
FormulaR1C1	D.S.[_3_]	Excel Programming	2	January 2nd 04 12:03 AM
FormulaR1C1	D.S.[_3_]	Excel Programming	0	January 1st 04 09:12 PM
FormulaR1C1	aapp81[_22_]	Excel Programming	3	December 3rd 03 10:47 PM

All times are GMT +1. The time now is 07:02 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us