S
selva
current file name how returned in cell in excel , same way in excel- current
page number to be returned in to a cell, how to do it?
page number to be returned in to a cell, how to do it?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Roar Hansen
=RIGHT(Cell("filename",A1),5)
the last argument is the number of characters in the filename.
Current page number ?
the last argument is the number of characters in the filename.
Current page number ?
S
selva
DEAR ROAR HANSEN
TO MAKE CLEAR , I AM LOOKING FOR, CURRENT PAGE NUMBER OF EXCEL SHEET ,TO BE
RETURNED TO EXCEL CELL IN CURRENT PAGE IT SELF .
WHERE PAGE NUMBERS ARE APPEARING IN EXCEL, ONLY IN HEADER FOOTER ONLY
I WOULD LIKE TO PULL THE PAGE NUMBERS TO CELL, SO THAT I WANT TO USE WITH
FORMULA
COULD U HELP ME
TO MAKE CLEAR , I AM LOOKING FOR, CURRENT PAGE NUMBER OF EXCEL SHEET ,TO BE
RETURNED TO EXCEL CELL IN CURRENT PAGE IT SELF .
WHERE PAGE NUMBERS ARE APPEARING IN EXCEL, ONLY IN HEADER FOOTER ONLY
I WOULD LIKE TO PULL THE PAGE NUMBERS TO CELL, SO THAT I WANT TO USE WITH
FORMULA
COULD U HELP ME
R
Roar
Selva,
Regarding File name, the function CELL will return the sheet name with whole
path (see Help). By combining with LEFT, RIGHT or MID, you can select part of
the path. Try the excample I gave.
Regarding Page number, there are no argument similar to "Filename". There
have been some questions about that before, but no replies. I don't think
there is a solution.
selva skrev:
Regarding File name, the function CELL will return the sheet name with whole
path (see Help). By combining with LEFT, RIGHT or MID, you can select part of
the path. Try the excample I gave.
Regarding Page number, there are no argument similar to "Filename". There
have been some questions about that before, but no replies. I don't think
there is a solution.
selva skrev:
G