Thread: VBA to place sheet name in cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Hammer_757[_7_] Hammer_757[_7_] is offline
external usenet poster
  
Posts: 1
Default VBA to place sheet name in cell

I am using a formula:
“Sheet "& MID(CELL("filename",B11),FIND("]",CELL("filename",B11))+2
LEN(CELL("filename",B11))-FIND("]",CELL("filename",B11))) “

to place part of the worksheet name in a cell. However because o
formatting requirements I cannot use a formula. Can I do this usin
VBA? Then I could have the macro run each time the workbook is close
to keep the cell up to date.

Thanks
Rober

--
Hammer_75
-----------------------------------------------------------------------
Hammer_757's Profile: http://www.excelforum.com/member.php...nfo&userid=741
View this thread: http://www.excelforum.com/showthread.php?threadid=40003

Reply With QuoteReply With Quote