Getting Cell A1 to match the sheetname?

  • Thread starter Thread starter sh0t2bts
  • Start date Start date
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...
 
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...
 
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...
 
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...
 
Back
Top