Posted to microsoft.public.excel.programming

Ed[_30_]

external usenet poster

Posts: 13

using a formula in a program

I'm trying to write a program which will use the formula
("=SUMIF(AA8:AA208,3,C8:C208)" in a loop, except that I'd like to change the
integer "3" in the formula to a variable so that I can increase this value
each time through the loop.

The program works as long as I leave the value an integer "3". "4", etc. But
I can't make it work with a variable.

Can someone give me a boost that might help me with this problem?

Thanks

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
how do i put a formula in a macro to run a program	holy41	Excel Worksheet Functions	1	July 8th 06 02:34 AM
My excel program will not let me edit in the formula bar.	Editing	Excel Discussion (Misc queries)	2	December 13th 05 03:11 AM
Program to make cell a formula	Craig	Excel Programming	4	September 29th 05 03:01 PM
Program formula Add On	Sean	Excel Programming	1	May 3rd 05 12:13 PM
Updating the formula by program	sameerce[_13_]	Excel Programming	7	May 27th 04 07:32 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us