Table access (1 Viewer)

BobNTN

Registered User.
Local time
Yesterday, 23:39
Joined
Jan 23, 2008
Messages
314
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?
 
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.
 
2024-11-13_10-34-13.gif
 
Last edited:
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.
 
maybe you can upload a sample workbook and tell us what value you need to find/edit.
 
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.
 
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...
 
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.
 
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.
 
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.
 
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
 
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
 

Users who are viewing this thread

Back
Top Bottom