I want to name my Sheet Tab then have that name automatically put in a cell
in Excel. I am using 2003, but would need it to work in 2000 also.
I want to name my Sheet Tab then have that name automatically put in a cell
in Excel. I am using 2003, but would need it to work in 2000 also.
Take a look at http://www.xldynamic.com/source/xld.xlFAQ0002.html
--
HTH
RP
(remove nothere from the email address if mailing direct)
"bryantebbe" <[email protected]> wrote in message
news:[email protected]...
> I want to name my Sheet Tab then have that name automatically put in a
cell
> in Excel. I am using 2003, but would need it to work in 2000 also.
Thanks Bob,
I knew it could be done, You were very helpful.
Bryan
"Bob Phillips" wrote:
> Take a look at http://www.xldynamic.com/source/xld.xlFAQ0002.html
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "bryantebbe" <[email protected]> wrote in message
> news:[email protected]...
> > I want to name my Sheet Tab then have that name automatically put in a
> cell
> > in Excel. I am using 2003, but would need it to work in 2000 also.
>
>
>
bryan
=MID(CELL("Filename",A1),FIND("]",CELL("Filename",A1))+1,255)
Enter in any cell.
Note: Workbook must have been saved at least once.
For more on this formula and others similar......path and name etc. see Bob
Phillips site.
http://www.xldynamic.com/source/xld.xlFAQ0002.html
Gord Dibben Excel MVP
On Wed, 19 Jan 2005 16:09:01 -0800, "bryantebbe"
<[email protected]> wrote:
>I want to name my Sheet Tab then have that name automatically put in a cell
>in Excel. I am using 2003, but would need it to work in 2000 also.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks