Posted to microsoft.public.excel.worksheet.functions

JRD-CFW[_2_] JRD-CFW[_2_] is offline

external usenet poster

Posts: 3

2 VB Questions

1) If I'm writing a worksheet_change for sheet1, how do i get it to reference
sheet2? That is, I want Sum(Sheet2!A2:A10)?

2) If I have A1=Sum(Range("A2:A10")) written into VB, how do I make it
update automatically when I change the value in, say, A3?

Thanks.

JRD-CFW

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
View Questions and Answer to questions I created	Roibn Taylor	Excel Discussion (Misc queries)	4	July 24th 08 12:05 AM
2 Questions	Rich Stanek	Excel Worksheet Functions	1	June 7th 07 09:43 AM
2 questions	Sally Sibthorpe	Charts and Charting in Excel	9	July 26th 06 10:15 PM
Max / IF questions	G	Excel Discussion (Misc queries)	1	October 12th 05 03:27 AM
Two Questions	mike	New Users to Excel	2	June 24th 05 12:35 AM

All times are GMT +1. The time now is 06:02 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us