Posted to microsoft.public.excel.programming

Costas

external usenet poster

Posts: 3

Worksheet functions in VB

I use a worksheet function in VB and specificly the sum
if. This is working properly but only for one cell what
is the easy way to do for a lot of cells.

Set Myrange = Sheet2.Range("a10:a100")
Sheet1.Range("f10") = _
Application.WorksheetFunction.SumIf((Myrange) _
, Sheet1.Range("b10"), Sheet2.Range("C10:C100"))

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
Help with worksheet functions	Angeline	Excel Discussion (Misc queries)	2	October 11th 06 11:19 PM
Worksheet functions	Joe D.	Excel Worksheet Functions	0	March 8th 06 02:24 PM
Worksheet functions	Nadji	New Users to Excel	2	June 10th 05 06:25 PM
worksheet functions	Nadji	Excel Worksheet Functions	1	June 10th 05 05:25 PM
help with worksheet functions	ksnapp[_40_]	Excel Programming	3	April 5th 04 10:48 PM

All times are GMT +1. The time now is 11:56 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us