How to get Value Cells for Sheets name

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.
 
B

Barb Reinhardt

I'm not sure what you are asking, but try

=CELL("filename",A1)

The workbook needs to be saved for it to work properly.
 
Top