Getting Cell A1 to match the sheetname?

S

sh0t2bts

Ken

I just get value returned when I use this, I did change the bit where is
says filename to my workbooks file name..


any ideas?

Cheers

Mark

Ken Wright said:
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

-------------------------------------------------------------------------- --
It's easier to beg forgiveness than ask permission :)
-------------------------------------------------------------------------- --



sh0t2bts said:
Hi All,

How can I get a cell value to match the sheetname?

Many Thanks

Mark
Click to expand...
Click to expand...
 
K

Ken Wright

Nope - Leave EXACTLY as is, but workbook must have been saved at least once for
it to work. :)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :)
----------------------------------------------------------------------------



sh0t2bts said:
Ken

I just get value returned when I use this, I did change the bit where is
says filename to my workbooks file name..


any ideas?

Cheers

Mark

Ken Wright said:
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

-------------------------------------------------------------------------- --
It's easier to beg forgiveness than ask permission :)
-------------------------------------------------------------------------- --



sh0t2bts said:
Hi All,

How can I get a cell value to match the sheetname?

Many Thanks

Mark
Click to expand...
Click to expand...
Click to expand...
 
S

sh0t2bts

Cheers

I have got it now.

Thank You


Ken Wright said:
Nope - Leave EXACTLY as is, but workbook must have been saved at least once for
it to work. :)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

-------------------------------------------------------------------------- --
It's easier to beg forgiveness than ask permission :)
-------------------------------------------------------------------------- --



sh0t2bts said:
Ken

I just get value returned when I use this, I did change the bit where is
says filename to my workbooks file name..


any ideas?

Cheers

Mark

Ken Wright said:
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03
Click to expand...
----------------------------------------------------------------------------------------------------------------------------------------------------
--



Hi All,

How can I get a cell value to match the sheetname?

Many Thanks

Mark
Click to expand...
Click to expand...
Click to expand...
 
K

Ken Wright

Good stuff, and always a pleasure :)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :)
----------------------------------------------------------------------------



sh0t2bts said:
Cheers

I have got it now.

Thank You


Ken Wright said:
Nope - Leave EXACTLY as is, but workbook must have been saved at least once for
it to work. :)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

-------------------------------------------------------------------------- --
It's easier to beg forgiveness than ask permission :)
-------------------------------------------------------------------------- --



sh0t2bts said:
Ken

I just get value returned when I use this, I did change the bit where is
says filename to my workbooks file name..


any ideas?

Cheers

Mark

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

--------------------------------------------------------------------------
--
It's easier to beg forgiveness than ask permission :)
--------------------------------------------------------------------------
--



Hi All,

How can I get a cell value to match the sheetname?

Many Thanks

Mark
Click to expand...
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Countif across multiple sheets - sheet NAME issue? 5
Using sumproduct function to count cell values on a remote workbook 3
Compare last digit in 5 cells for match 0
Auto insert sheetname into chart title? 5
How to write a macro that will clear validated cells to blank? 3
Using a cell to reference sheetname in vlookup function 1
Match issue 3
Match function: error due to format? 4

Top