How to change the Tables! ?

X

xlsstudent

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

When I did the Insert>Name> 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.
 
G

Gord Dibben

Quite likely the Tables sheet is hidden.

Format>Sheet>Unhide and do your addition of values then re-define the reference
address to fit your new list.


Gord
 
G

Gord Dibben

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
 
Top