Table access

[BobNTN]

I have a range (values) which is located in a table (CardTable) I am trying to locate to edit.
I have searched and tried everything I can find but no luck. (Find and Go To, Name Manager, List tables, list worksheets, etc)
The entry in Name Manager refers to (=CardTable!$B$6:$C$13). The range name is Values. It works fine but I need to locate and edit.

Anyone have any ideas?

 

[Pat Hartman]

I don't understand the question. Are you trying to work with the range using Access or is this an Excel question? With Access, you can import or link directly to the range.

 

[KitaYama]

 

[BobNTN]

I don't understand the question. Are you trying to work with the range using Access or is this an Excel question? With Access, you can import or link directly to the range.

Excel. I can't find a way to pull it up (existing) to edit the range nor table.

 

[arnelgp]

maybe you can upload a sample workbook and tell us what value you need to find/edit.

 

[BobNTN]

maybe you can upload a sample workbook and tell us what value you need to find/edit.

I am trying to open (find, see, etc) a table so I can edit it. The file is most likely too large to upload.

 

[arnelgp]

I am trying to open (find, see, etc) a table

you already have it on your #1 post.
(=CardTable!$B$6:$C$13).

it is on sheet CardTable and on range B6:C13.

if the sheet CardTable is not visible, right click on any Sheet Name and choose Unhide...

 

[BobNTN]

you already have it on your #1 post.
(=CardTable!$B$6:$C$13).

it is on sheet CardTable and on range B6:C13.

if the sheet CardTable is not visible, right click on any Sheet Name and choose Unhide...

I have tried that. No matter where I right click. Not listed. I have tried find and go to, does nothing. I have tried everything I could find from searching for it. Really a mystery.
I think I will just create and use another table.
Thanks anyway.

 

[arnelgp]

if you can go to VBA (Developer->Visual Basic),
you type this in Immediate window:

application.Sheets("CardTable").Visible=xlSheetVisible

this will make the sheet visible.
the reason you can't Unhide it is it is Deep Hidden.

 

[BobNTN]

if you can go to VBA (Developer->Visual Basic),
you type this in Immediate window:

application.Sheets("CardTable").Visible=xlSheetVisible

this will make the sheet visible.
the reason you can't Unhide it is it is Deep Hidden.

Deep Hidden? Never heard that term.
Ok, thank you so much.

 

[arnelgp]

Deep Hidden? Never heard that term.

the Visible property is set to xlSheetVeryHidden

 

[arnelgp]

if you caannot go to vba because the Developer Tab is not visible, go to File->Options->Customize Ribbon.
on the Right pane (Main tabs), browse for Developer and Tick mark it. press OK.
then on the Ribbon->Developer->Visual Basic.
on Immediate window you type:

application.Sheets("CardTable").Visible=xlSheetVisible

 

[BobNTN]

if you caannot go to vba because the Developer Tab is not visible, go to File->Options->Customize Ribbon.
on the Right pane (Main tabs), browse for Developer and Tick mark it. press OK.
then on the Ribbon->Developer->Visual Basic.
on Immediate window you type:

application.Sheets("CardTable").Visible=xlSheetVisible

Thanks