How can I get the name of a worksheet in a cell of that worksheet? Thank you
W worksheetname in a cell Oct 27, 2003 #1 How can I get the name of a worksheet in a cell of that worksheet? Thank you
J J.E. McGimpsey Oct 27, 2003 #2 one way: =MID(CELL("filename",A1), FIND("]", CELL("filename",A1))+1, 255) Note: The file needs to be saved for this to work.
one way: =MID(CELL("filename",A1), FIND("]", CELL("filename",A1))+1, 255) Note: The file needs to be saved for this to work.
T Tommy Flynn Oct 27, 2003 #3 Sub ShowName() Range("A1") = ActiveSheet.Name End Sub Regards, Tommy Flynn J.E. McGimpsey said: one way: =MID(CELL("filename",A1), FIND("]", CELL("filename",A1))+1, 255) Note: The file needs to be saved for this to work. How can I get the name of a worksheet in a cell of that worksheet? Thank you Click to expand... Click to expand...
Sub ShowName() Range("A1") = ActiveSheet.Name End Sub Regards, Tommy Flynn J.E. McGimpsey said: one way: =MID(CELL("filename",A1), FIND("]", CELL("filename",A1))+1, 255) Note: The file needs to be saved for this to work. How can I get the name of a worksheet in a cell of that worksheet? Thank you Click to expand... Click to expand...
