How to get Value Cells for Sheets name

  • Thread starter Thread starter vumian
  • Start date Start date
V

vumian

with many sheet, i don't know before, it depends on files

how to get value of $cell that named for that sheet

ths for helping.
best wish.
 
I'm not sure what you are asking, but try

=CELL("filename",A1)

The workbook needs to be saved for it to work properly.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula to consolidate 130 sheets into a summary sheet 6
Get Name of Sheet to use in Macro 11
Excel lookup across entire workbook 1
Need a formula to act as a value 1
COUNTIF + ADDRESS Issue 1
CONDITIONAL FORMATTING BETWEEN SHEETS 1
Auto Sheet Names and Date cells 3
VBA Macro - Copying specific data to different sheets in a workbookand linking the InputBox to a com 7

Back
Top