functions across sheets

J

joel

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?
 
B

Bob Phillips

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)
 
D

David McRitchie

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.
 
Top