Copy Worksheet tab in a cell

By mario58 ·
Does anybody know how to copy the sheet tab name to a cell in the worksheet, without writing any code?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

One way worked for me on MS Home & Student 07

by too_old In reply to Copy Worksheet tab in a c ...

One can copy the sheet tab name while in the 'rename' or before hitting return when creating the tab name, then just paste to the cell. When copying the tab name, I just made sure it was smeared, typed <crtl> c, then make sure the tab name is no longer smeared and cursor at the end before hitting return to retain the name of the sheet. Hope it works for you.

Collapse -

Copy Excel sheet tab in worksheet

by mario58 In reply to this should do it.

Thank you Paul. It is just what I wanted. Thanks indeed for your wonderful and kind help.

Related Discussions

Related Forums