Posted to microsoft.public.excel.programming

Rick B[_6_] Rick B[_6_] is offline

external usenet poster

Posts: 12

modifying formulas with code

I have a workbook where values in row C contain worksheet names. VBA code
creates additional worksheets naming the worksheet with what is entered in
column C. There is also a summary worksheet which Sums like cells from all
the worksheets. Looking for assistance in creating code which would modify
the SUM formula on the summary worksheet each time new worksheets are added.

-Rick

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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
Modifying sumif formulas.	Hirsch	Excel Worksheet Functions	4	June 17th 05 04:15 AM
Modifying formulas through code	Rick B[_6_]	Excel Programming	1	January 23rd 04 11:24 PM
Need Help Modifying Code	JStone0218	Excel Programming	2	January 19th 04 10:27 AM
Help modifying code	BruceJ[_2_]	Excel Programming	1	December 10th 03 12:52 AM
Modifying Code that deletes a Row	Todd Huttenstine[_2_]	Excel Programming	2	November 27th 03 10:41 PM

All times are GMT +1. The time now is 09:27 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us