Forum Discussion
Filename
Hello I´m using the Cell(filename) function, and this is working. But I have 2 or more Excel sheets open, with the same formula but different file names. But when I work in one file, it chan...
Cell("Filename",CellRef) returns the current Workbook name,,, please share the file you are working with, will help us to examine.
I tried this but this does not work.
- Better upload the workbook and mark the cell in which you have applied the formula and let me examine,,, also if possible show me the expected output.
Found it:)
by adding A1 in the referene it refferes to the current sheet and not the aktive one. 🙂
