=cell(filename) help

[Antonio]

Hi guys,

I have a great formula that returns the name of every tab
I have in my workbook.

=RIGHT(CELL("filename",'Jul-04'!$A$1),LEN(CELL
("filename",'Jul-04'!$A$1))-FIND("]",CELL("filename",'Jul-
04'!$A$1),1))

I was wondering if anyone knows how to manipulate this
formula so I get only the 04 part of the formula. Each
tab is a month and a year. So for example if the tab is
Jul-04, I want a formula to return only 04.

Than I want to combine that formula with this one:

"INSTYLE "&F12&" 2002"

so instead of the user to have to go back and change 2002
to 2004. the formula will do it automatically

Any ideas?

Antonio

 

[Bob Phillips]

Antonio,

Put this in an adjacent cell

=MID(F8,FIND("-",F8)+1,99)

change F8 to your cell

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[ant]

Thanks Bob

Worked like a charm

-----Original Message-----
Antonio,

Put this in an adjacent cell

=MID(F8,FIND("-",F8)+1,99)

change F8 to your cell

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Hi guys,

I have a great formula that returns the name of every tab
I have in my workbook.

=RIGHT(CELL("filename",'Jul-04'!$A$1),LEN(CELL
("filename",'Jul-04'!$A$1))-FIND("]",CELL ("filename",'Jul-
04'!$A$1),1))

I was wondering if anyone knows how to manipulate this
formula so I get only the 04 part of the formula. Each
tab is a month and a year. So for example if the tab is
Jul-04, I want a formula to return only 04.

Than I want to combine that formula with this one:

"INSTYLE "&F12&" 2002"

so instead of the user to have to go back and change 2002
to 2004. the formula will do it automatically

Any ideas?

Antonio

.