Posted to microsoft.public.excel.programming

Nick

external usenet poster

Posts: 17

Add large ammount of formula

Thanks all .

Thanks

Nick

Soo Cheon Jheong wrote:

Nick,

Try
- - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Sub TEST_1()
Range("C1:C1000").Formula = "=A1+B1"
End Sub

Sub TEST_2()
Range("C1:C1000").Value = "=A1+B1"
End Sub

Sub TEST_3()
Range("C1:C1000").Formula = "=RC[-2]+RC[-1]"
End Sub

Sub TEST_4()
Range("C1:C1000").Value = "=RC[-2]+RC[-1]"
End Sub

- - - - - - - - - - - - - - - - - - - - - - - - - - - - -

--
Regards,
Soo Cheon Jheong
_ _
^¢¯^
--

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
Large formula	BuckinB	Excel Worksheet Functions	7	November 3rd 09 06:29 PM
Formula too large	Cindyt	Excel Discussion (Misc queries)	4	July 14th 09 07:31 PM
How many chart types does excel have: please exact ammount?	GuyGardner89	Charts and Charting in Excel	3	November 13th 08 01:59 AM
How many chart types does excel have: please exact ammount?	GuyGardner89	Excel Discussion (Misc queries)	1	November 12th 08 01:54 AM
Program colunm to switch receievable ammount from 30 to 60 days	Steph	Excel Discussion (Misc queries)	1	November 26th 07 07:37 PM

All times are GMT +1. The time now is 09:18 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us