View Single Post
  #5   Report Post  
Dawg House Inc
 
Posts: n/a
Default

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