i have looked a little but can't find what i think is the right thing.
i have a workbook with 3-4 pages in it. in the upper righthand corner
is a page of pages cells set up. i want to have it grab the current
tab(page) for one cell and the rest of the tabs(pages) for the other
cell. i am not very good at the coding VB thing so exact instructions
would be grately appreciated. i have tried a few of the suggestions but
cannot get them to work. i am using excel 2002. TIA