Wondering about a simple function that excel should have RRS feed

  • Question

  • how can a cell reference itself to find the name of the page it is on

    I numbered my pages and i am trying to get the cell to reference itself for the sheet name (which is a number) and minus 1 from it to get the sheet name(which is a number) of a previous page?

     any clue on how this can be done

    Monday, April 7, 2014 4:01 AM


  • The formula


    returns the sheet name. So if that is a number,


    returns "sheet name minus 1".

    Remark: this only works if the workbook has been saved, not in a newly created workbook that has never been saved yet.

    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    Monday, April 7, 2014 4:30 AM