XL2K - can we put TAB name coding into cells in a sheet body?

[StargateFan]

I do this all the time in the header or footer wherever needed by
using the "&[Tab]" feature available; however, is there some coding
that we can put into a cell that will do the same anywhere on the body
of the sheet itself?

I couldn't find the exact planner sheets I needed at stores for my new
planner so I ended up creating my own pages last night. I'd like to
add the tab name somewhere on the bottom of individual page of which 3
fit on each worksheet. This way, if I ever change the tab names or
copy them for use as templates for other forms, I won't have to worry
about changing the name on 3 cells on every sheet's "page". So far
I've made 2 different page styles with 3 copies on each sheet for a
total of 6 planner pages to print out. I'd hate to have to manually
add the tab names to 6 cells each time there's a change! <g>

Tx.

 

[Dave Peterson]

Visit Debra Dalgleish's site for a way to put the worksheet name into a cell:
http://contextures.com/xlfaqFun.html#SheetName

I'm kind of confused about the second part, though.

I do this all the time in the header or footer wherever needed by
using the "&[Tab]" feature available; however, is there some coding
that we can put into a cell that will do the same anywhere on the body
of the sheet itself?

I couldn't find the exact planner sheets I needed at stores for my new
planner so I ended up creating my own pages last night. I'd like to
add the tab name somewhere on the bottom of individual page of which 3
fit on each worksheet. This way, if I ever change the tab names or
copy them for use as templates for other forms, I won't have to worry
about changing the name on 3 cells on every sheet's "page". So far
I've made 2 different page styles with 3 copies on each sheet for a
total of 6 planner pages to print out. I'd hate to have to manually
add the tab names to 6 cells each time there's a change! <g>

Tx.

 

[StargateFan]

Visit Debra Dalgleish's site for a way to put the worksheet name into a cell:
http://contextures.com/xlfaqFun.html#SheetName

That's the general idea, this is one step closer. That's great. What
I specifically need is this:

- tab name not sheet name
- no path, just the name

to mimic what "&[Tab]" does.

Any way to do? Tx.

I'm kind of confused about the second part, though.

I do this all the time in the header or footer wherever needed by
using the "&[Tab]" feature available; however, is there some coding
that we can put into a cell that will do the same anywhere on the body
of the sheet itself?

I couldn't find the exact planner sheets I needed at stores for my new
planner so I ended up creating my own pages last night. I'd like to
add the tab name somewhere on the bottom of individual page of which 3
fit on each worksheet. This way, if I ever change the tab names or
copy them for use as templates for other forms, I won't have to worry
about changing the name on 3 cells on every sheet's "page". So far
I've made 2 different page styles with 3 copies on each sheet for a
total of 6 planner pages to print out. I'd hate to have to manually
add the tab names to 6 cells each time there's a change! <g>

Tx.

 

[StargateFan]

Visit Debra Dalgleish's site for a way to put the worksheet name into a cell:
http://contextures.com/xlfaqFun.html#SheetName

That's the general idea, this is one step closer. That's great. What
I specifically need is this:

- tab name not sheet name
- no path, just the name

to mimic what "&[Tab]" does.

Any way to do? Tx.

From that page above, here is the info:

"Is there way of returning the name of a sheet in a cell without using
code?

=CELL("Filename",A1) returns the complete file path and sheet name

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255) will
strip away everything but the sheet name.

Note: The file must be saved or the formula will not work."



Okay, don't know what initially went wrong but the first "cell" code I
used didn't work at all even though the file is a saved one. It did
work, however, when I left the ",A1" out of the formula. I put the
code for the =MID(CELL... just now in the same cell to get just the
tab name thinking I'd have to spend quite a few minutes trying to
figure out now how to get it to work. But lo and behold, no problems
(?). I don't know why the first doesn't and the second does but alls
well that ends well. Sorry I got all muddled up. This seems to be
fine now. Phew.

Thanks!

 

[Dave Peterson]

Make sure the workbook was saved, first, then copy the formula and paste
directly into the formula bar (after selecting the cell).

If you don't include that last reference, then this formula will evaluate to the
workbook that was active during the last calculation.

If you open two workbooks and put:
=cell("Filename")
in A1 of a worksheet in each workbook
then use window|arrange|tiled
to see both worksheets,
you'll see the difference.

Visit Debra Dalgleish's site for a way to put the worksheet name into a cell:
http://contextures.com/xlfaqFun.html#SheetName

That's the general idea, this is one step closer. That's great. What
I specifically need is this:

- tab name not sheet name
- no path, just the name

to mimic what "&[Tab]" does.

Any way to do? Tx.

From that page above, here is the info:

"Is there way of returning the name of a sheet in a cell without using
code?

=CELL("Filename",A1) returns the complete file path and sheet name

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255) will
strip away everything but the sheet name.

Note: The file must be saved or the formula will not work."

Okay, don't know what initially went wrong but the first "cell" code I
used didn't work at all even though the file is a saved one. It did
work, however, when I left the ",A1" out of the formula. I put the
code for the =MID(CELL... just now in the same cell to get just the
tab name thinking I'd have to spend quite a few minutes trying to
figure out now how to get it to work. But lo and behold, no problems
(?). I don't know why the first doesn't and the second does but alls
well that ends well. Sorry I got all muddled up. This seems to be
fine now. Phew.

Thanks!

 

[StargateFan]

Make sure the workbook was saved, first, then copy the formula and paste
directly into the formula bar (after selecting the cell).

Hi!

Yes, I'd done that. My conclusion is that since it was in A1 perhaps
that was why the first code doesn't work (?). The doct was saved.
I'm using xls format for these instead of xlt for that reason.
Anyway, alls well that ends well and it works. What's really neat is
that I get 3 "pages" onto one legal-sized sheet of bond paper that I
just quickly cut up. So no matter where I am in the world (and I'll
be visiting family around Xmas), if I can get onto a machine with
Excel 2000 at least, I can print out planner pages for my Daytimer!
(They just don't carry the style I need.) <g> And when I make new
sheets and change the tab name, don't have to code each one in. Not
too shabby.

If you don't include that last reference, then this formula will evaluate to the
workbook that was active during the last calculation.

If you open two workbooks and put:
=cell("Filename")
in A1 of a worksheet in each workbook
then use window|arrange|tiled
to see both worksheets,
you'll see the difference.

On Sat, 29 Oct 2005 09:00:15 -0500, Dave Peterson

Visit Debra Dalgleish's site for a way to put the worksheet name into a cell:
http://contextures.com/xlfaqFun.html#SheetName

That's the general idea, this is one step closer. That's great. What
I specifically need is this:

- tab name not sheet name
- no path, just the name

to mimic what "&[Tab]" does.

Any way to do? Tx.

From that page above, here is the info:

"Is there way of returning the name of a sheet in a cell without using
code?

=CELL("Filename",A1) returns the complete file path and sheet name

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255) will
strip away everything but the sheet name.

Note: The file must be saved or the formula will not work."

Okay, don't know what initially went wrong but the first "cell" code I
used didn't work at all even though the file is a saved one. It did
work, however, when I left the ",A1" out of the formula. I put the
code for the =MID(CELL... just now in the same cell to get just the
tab name thinking I'd have to spend quite a few minutes trying to
figure out now how to get it to work. But lo and behold, no problems
(?). I don't know why the first doesn't and the second does but alls
well that ends well. Sorry I got all muddled up. This seems to be
fine now. Phew.

Thanks!

 

[Dave Peterson]

Glad you got it working.

Make sure the workbook was saved, first, then copy the formula and paste
directly into the formula bar (after selecting the cell).

Hi!

Yes, I'd done that. My conclusion is that since it was in A1 perhaps
that was why the first code doesn't work (?). The doct was saved.
I'm using xls format for these instead of xlt for that reason.
Anyway, alls well that ends well and it works. What's really neat is
that I get 3 "pages" onto one legal-sized sheet of bond paper that I
just quickly cut up. So no matter where I am in the world (and I'll
be visiting family around Xmas), if I can get onto a machine with
Excel 2000 at least, I can print out planner pages for my Daytimer!
(They just don't carry the style I need.) <g> And when I make new
sheets and change the tab name, don't have to code each one in. Not
too shabby.

If you don't include that last reference, then this formula will evaluate to the
workbook that was active during the last calculation.

If you open two workbooks and put:
=cell("Filename")
in A1 of a worksheet in each workbook
then use window|arrange|tiled
to see both worksheets,
you'll see the difference.

On Sat, 29 Oct 2005 10:11:02 -0400, StargateFan

On Sat, 29 Oct 2005 09:00:15 -0500, Dave Peterson

Visit Debra Dalgleish's site for a way to put the worksheet name into a cell:
http://contextures.com/xlfaqFun.html#SheetName

That's the general idea, this is one step closer. That's great. What
I specifically need is this:

- tab name not sheet name
- no path, just the name

to mimic what "&[Tab]" does.

Any way to do? Tx.

From that page above, here is the info:

"Is there way of returning the name of a sheet in a cell without using
code?

=CELL("Filename",A1) returns the complete file path and sheet name

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255) will
strip away everything but the sheet name.

Note: The file must be saved or the formula will not work."

Okay, don't know what initially went wrong but the first "cell" code I
used didn't work at all even though the file is a saved one. It did
work, however, when I left the ",A1" out of the formula. I put the
code for the =MID(CELL... just now in the same cell to get just the
tab name thinking I'd have to spend quite a few minutes trying to
figure out now how to get it to work. But lo and behold, no problems
(?). I don't know why the first doesn't and the second does but alls
well that ends well. Sorry I got all muddled up. This seems to be
fine now. Phew.

Thanks!