How to change the Tables! ?
 

Thanks for all those who helped to find the data location of the list.

When I did the InsertName Define, I see the name of the list TBL_PEOPLE.
When I click on the name, it shows
=OFFSET(Tables!$D$1,1,0,COUNTA(Tables!$D:$D)-1,1)

However, I am not able to see any worksheet by name Tables. what should I do
to include few more values into this list? Pls help.

How to change the Tables! ?
 

Quite likely the Tables sheet is hidden.

FormatSheetUnhide and do your addition of values then re-define the reference
address to fit your new list.


Gord

On Thu, 24 May 2007 11:54:00 -0700, xlsstudent
wrote:

Thanks for all those who helped to find the data location of the list.

When I did the InsertName Define, I see the name of the list TBL_PEOPLE.
When I click on the name, it shows
=OFFSET(Tables!$D$1,1,0,COUNTA(Tables!$D:$D)-1,1)

However, I am not able to see any worksheet by name Tables. what should I do
to include few more values into this list? Pls help.

How to change the Tables! ?
 

Gord,

Appreciate your help and response. That was my first hunch. I searched for
any hidden worksheet but could not find one. I saw if the document is
protected for any changes. Nope. The document is not protected either.

Pls help.

"Gord Dibben" wrote:

Quite likely the Tables sheet is hidden.

FormatSheetUnhide and do your addition of values then re-define the reference
address to fit your new list.


Gord

On Thu, 24 May 2007 11:54:00 -0700, xlsstudent
wrote:

Thanks for all those who helped to find the data location of the list.

When I did the InsertName Define, I see the name of the list TBL_PEOPLE.
When I click on the name, it shows
=OFFSET(Tables!$D$1,1,0,COUNTA(Tables!$D:$D)-1,1)

However, I am not able to see any worksheet by name Tables. what should I do
to include few more values into this list? Pls help.

How to change the Tables! ?
 

Maybe it was hidden using VBA's xlveryhidden method.

Try this macro.

Sub unhide()
Dim sh As Worksheet
For Each sh In ActiveWorkbook.Sheets
sh.Visible = True
Next sh
End Sub

Or hit Alt + F11 to open VBE......CTRL + g to open Immediate window.

Paste this in and hit <enter

Sheets("Tables").Visible = true


Gord

On Thu, 24 May 2007 15:32:01 -0700, xlsstudent
wrote:

Gord,

Appreciate your help and response. That was my first hunch. I searched for
any hidden worksheet but could not find one. I saw if the document is
protected for any changes. Nope. The document is not protected either.

Pls help.

"Gord Dibben" wrote:

Quite likely the Tables sheet is hidden.

FormatSheetUnhide and do your addition of values then re-define the reference
address to fit your new list.


Gord

On Thu, 24 May 2007 11:54:00 -0700, xlsstudent
wrote:

Thanks for all those who helped to find the data location of the list.

When I did the InsertName Define, I see the name of the list TBL_PEOPLE.
When I click on the name, it shows
=OFFSET(Tables!$D$1,1,0,COUNTA(Tables!$D:$D)-1,1)

However, I am not able to see any worksheet by name Tables. what should I do
to include few more values into this list? Pls help.