Posted to microsoft.public.excel.programming

dorre

external usenet poster

Posts: 12

programatically entering a CSE formula

hi folks

What is the correct way to enter a CSE formula into a range of cells?

With Sheet1
.Range("A10:C70").Formula = "=SUM(lARGE((" .... etc... "
End With

This works for non-CSE formulas, but how do I enter CSE ones?

much thanks
Dorre

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
Entering Formula - Cannot select cell as it is hidden by formula	Jim	Excel Worksheet Functions	0	March 25th 10 07:22 AM
Problems entering Data validation Programatically	J Streger	Excel Programming	3	April 1st 05 05:30 PM
Inserting formula programatically	Tony	Excel Programming	3	February 3rd 05 10:13 AM
Programatically Entering an Array Formula	John C.[_4_]	Excel Programming	1	July 28th 04 01:53 AM
modify cell references in a formula programatically	ralphehowardjr	Excel Programming	2	December 20th 03 01:18 PM

All times are GMT +1. The time now is 08:06 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us