Sorry for the confusion:
I want a cell to reference a particular worksheets Name property. I then
want the cell below it to reference the Next worksheet's Name property. So,
if I have 40 sheets, I'll have 40 cells that have some sort of function in
them that would refer to the worksheets' Names in my Active Workbook.
For example: Sheet 2 - Testing; Sheet 3 - Development; Sheet 4 - Quality
Assurance
Then, on sheet 1 - Table of Contents, I would like to have cells A2:A4
show as follows:
Testing
Development
Quality Assurance
Does that clear it up? My apologies again....
JCH
"Fredrik Wahlgren" wrote:
"Dawg House Inc" wrote in message
...
Is there a way I can, in the first worksheet of 40, type in a cell a
function
that will return me the name of another worksheet? I know how to return
the
CURRENT worksheet.
I thought I could use the Worksheets collection and the Name property, but
I
am stunned and brain dead right now, and if that is a possibility, I can't
get it to work.
Any and all help is muchly appreciated.
--
Dawg House Inc.
"We live in it, therefore, we know it!"
I'm not sure I understand what you want. Let's say you have n worksheets. Do
you want a function that takes a paramter, like position, and returns the
name of the n:th worksheet?
/Fredrik
|