functions across sheets
 

How does one use stored addresses to set values on another
sheet in VB? Let's say I have several cells grouped
together. How should I go about storing that refference and
then on ANOTHER sheet, set a cell equal to the SUM or
AVERAGE (or any of the other functions) of these cells?

functions across sheets
 

Joel,

I thin k I understand, so take a look at INDIRECT in help.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"joel" wrote in message
...
How does one use stored addresses to set values on another
sheet in VB? Let's say I have several cells grouped
together. How should I go about storing that refference and
then on ANOTHER sheet, set a cell equal to the SUM or
AVERAGE (or any of the other functions) of these cells?

functions across sheets
 

Less sure I understand you but take a look anyway at
Build TOC Another Approach
http://www.mvps.org/dmcritchie/excel/buildtoc2.htm
which uses INDIRECT to obtain values from other
sheets that have information in same cell on each sheet.

Keep in mind that Functions have to return a value and
not put a value somewhere else.

INDIRECT Worksheet Function (obviously unfinished)
http://www.mvps.org/dmcritchie/excel/indirect.htm
in the related area suggest getting Peter Noneley's workbook

Posting anonymously in technical newsgroups is rather
self defeating. Suggest you include first and lastname and
use a hotmail address specifically for using newsgroups
and check it frequently. The first part of the address should
not be same as your regular email address if you are really
concerned with spam as robots would just add a thousand
different domain names and hit your normal address. Use
the medium setting in Hotmail to eliminate most spam and
let most legitimate messages come through.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Bob Phillips" wrote in message
I think I understand, so take a look at INDIRECT in help.

"joel" wrote ...
How does one use stored addresses to set values on another
sheet in VB? Let's say I have several cells grouped
together. How should I go about storing that reference and
then on ANOTHER sheet, set a cell equal to the SUM or
AVERAGE (or any of the other functions) of these cells?