Check out
http://www.mcgimpsey.com/excel/formu..._function.html
In article <[email protected]>,
"Hawk186" <[email protected]> wrote:
> The tab is named '522' and I want '522' to show up in a cell in the worksheet
> such as A1. I know that =CELL can be used to get the filenam, but can it be
> used to get the tab name? If not, is there another function that will?
The tab is named '522' and I want '522' to show up in a cell in the worksheet
such as A1. I know that =CELL can be used to get the filenam, but can it be
used to get the tab name? If not, is there another function that will?
You can also use a UDF for this. The CELL function has a known bug (not
sure if MS fixed it or not); generally it will work just fine though. An
example of a worskheet function (UDF) that will accomplish this canbe found
here:
http://www.vbaexpress.com/kb/getarticle.php?kb_id=401
HTH
--
Regards,
Zack Barresse, aka firefytr
"Hawk186" <[email protected]> wrote in message
news:[email protected]...
> The tab is named '522' and I want '522' to show up in a cell in the
> worksheet
> such as A1. I know that =CELL can be used to get the filenam, but can it
> be
> used to get the tab name? If not, is there another function that will?
Did you ever get a specific answer to your question? I'm looking for the
same info.
"Hawk186" wrote:
> The tab is named '522' and I want '522' to show up in a cell in the worksheet
> such as A1. I know that =CELL can be used to get the filenam, but can it be
> used to get the tab name? If not, is there another function that will?
I think you can use this:
=MID(CELL("filename",A1), FIND("]", CELL("filename", A1))+ 1, 255)
Did you ever get a specific answer to your question? I'm looking for the
same info.
"Hawk186" wrote:
> The tab is named '522' and I want '522' to show up in a cell in the worksheet
> such as A1. I know that =CELL can be used to get the filenam, but can it be
> used to get the tab name? If not, is there another function that will?
Did you ever get a specific answer to your question? I'm looking for the
same info.
"Hawk186" wrote:
> The tab is named '522' and I want '522' to show up in a cell in the worksheet
> such as A1. I know that =CELL can be used to get the filenam, but can it be
> used to get the tab name? If not, is there another function that will?
Did you ever get a specific answer to your question? I'm looking for the
same info.
"Hawk186" wrote:
> The tab is named '522' and I want '522' to show up in a cell in the worksheet
> such as A1. I know that =CELL can be used to get the filenam, but can it be
> used to get the tab name? If not, is there another function that will?
Did you ever get a specific answer to your question? I'm looking for the
same info.
"Hawk186" wrote:
> The tab is named '522' and I want '522' to show up in a cell in the worksheet
> such as A1. I know that =CELL can be used to get the filenam, but can it be
> used to get the tab name? If not, is there another function that will?
Did you ever get a specific answer to your question? I'm looking for the
same info.
"Hawk186" wrote:
> The tab is named '522' and I want '522' to show up in a cell in the worksheet
> such as A1. I know that =CELL can be used to get the filenam, but can it be
> used to get the tab name? If not, is there another function that will?
Did you ever get a specific answer to your question? I'm looking for the
same info.
"Hawk186" wrote:
> The tab is named '522' and I want '522' to show up in a cell in the worksheet
> such as A1. I know that =CELL can be used to get the filenam, but can it be
> used to get the tab name? If not, is there another function that will?
Did you ever get a specific answer to your question? I'm looking for the
same info.
"Hawk186" wrote:
> The tab is named '522' and I want '522' to show up in a cell in the worksheet
> such as A1. I know that =CELL can be used to get the filenam, but can it be
> used to get the tab name? If not, is there another function that will?
Did you ever get a specific answer to your question? I'm looking for the
same info.
"Hawk186" wrote:
> The tab is named '522' and I want '522' to show up in a cell in the worksheet
> such as A1. I know that =CELL can be used to get the filenam, but can it be
> used to get the tab name? If not, is there another function that will?
Did you ever get a specific answer to your question? I'm looking for the
same info.
"Hawk186" wrote:
> The tab is named '522' and I want '522' to show up in a cell in the worksheet
> such as A1. I know that =CELL can be used to get the filenam, but can it be
> used to get the tab name? If not, is there another function that will?
Did you ever get a specific answer to your question? I'm looking for the
same info.
"Hawk186" wrote:
> The tab is named '522' and I want '522' to show up in a cell in the worksheet
> such as A1. I know that =CELL can be used to get the filenam, but can it be
> used to get the tab name? If not, is there another function that will?
Did you ever get a specific answer to your question? I'm looking for the
same info.
"Hawk186" wrote:
> The tab is named '522' and I want '522' to show up in a cell in the worksheet
> such as A1. I know that =CELL can be used to get the filenam, but can it be
> used to get the tab name? If not, is there another function that will?
Did you ever get a specific answer to your question? I'm looking for the
same info.
"Hawk186" wrote:
> The tab is named '522' and I want '522' to show up in a cell in the worksheet
> such as A1. I know that =CELL can be used to get the filenam, but can it be
> used to get the tab name? If not, is there another function that will?
Did you ever get a specific answer to your question? I'm looking for the
same info.
"Hawk186" wrote:
> The tab is named '522' and I want '522' to show up in a cell in the worksheet
> such as A1. I know that =CELL can be used to get the filenam, but can it be
> used to get the tab name? If not, is there another function that will?
Did you ever get a specific answer to your question? I'm looking for the
same info.
"Hawk186" wrote:
> The tab is named '522' and I want '522' to show up in a cell in the worksheet
> such as A1. I know that =CELL can be used to get the filenam, but can it be
> used to get the tab name? If not, is there another function that will?
Did you ever get a specific answer to your question? I'm looking for the
same info.
"Hawk186" wrote:
> The tab is named '522' and I want '522' to show up in a cell in the worksheet
> such as A1. I know that =CELL can be used to get the filenam, but can it be
> used to get the tab name? If not, is there another function that will?
Did you ever get a specific answer to your question? I'm looking for the
same info.
"Hawk186" wrote:
> The tab is named '522' and I want '522' to show up in a cell in the worksheet
> such as A1. I know that =CELL can be used to get the filenam, but can it be
> used to get the tab name? If not, is there another function that will?
Did you ever get a specific answer to your question? I'm looking for the
same info.
"Hawk186" wrote:
> The tab is named '522' and I want '522' to show up in a cell in the worksheet
> such as A1. I know that =CELL can be used to get the filenam, but can it be
> used to get the tab name? If not, is there another function that will?
Did you ever get a specific answer to your question? I'm looking for the
same info.
"Hawk186" wrote:
> The tab is named '522' and I want '522' to show up in a cell in the worksheet
> such as A1. I know that =CELL can be used to get the filenam, but can it be
> used to get the tab name? If not, is there another function that will?
Did you ever get a specific answer to your question? I'm looking for the
same info.
"Hawk186" wrote:
> The tab is named '522' and I want '522' to show up in a cell in the worksheet
> such as A1. I know that =CELL can be used to get the filenam, but can it be
> used to get the tab name? If not, is there another function that will?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks