3D range problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

br549 - 15 Jun 2007 18:50 GMT

I need to calculate standard deviation for data located on multiple
worksheets. The problem is that the number of worksheets changes from time to
time. I want the calculation to automatically adjust to include data from the
third worksheet up however many worksheets there are in the workbook at the
time.

Searching for ways to do this leads me to believe there were
"get.workbook()" and "get.document()" functions in older versions of Excel
that can be used in Define|Names, but I can't find a reference for the
arguments (I do know that (76) gives current sheet name, and (87) gives
current sheet position).

Any thoughts on how to do this?

Reply to this Message

bj - 15 Jun 2007 20:52 GMT

if it is a common range in each worksheet, try
insert a worksheet before Worksheet 3
Name it "Start"
add a worksheet after the last worksheet
Name it "Last"

=stedev(Start:Last!range)

insert any new worksheets between
Start and Last

> I need to calculate standard deviation for data located on multiple
> worksheets. The problem is that the number of worksheets changes from time to
[quoted text clipped - 9 lines]
>
> Any thoughts on how to do this?

Reply to this Message