how do I enter text in a cell in an excel worksheet to match the name of the active worksheet?
B Buzzband Oct 15, 2004 #1 how do I enter text in a cell in an excel worksheet to match the name of the active worksheet?
J Jason Morin Oct 15, 2004 #2 Try: =RIGHT(CELL("filename",A1),LEN(CELL("filename",A1))-FIND ("]",CELL("filename",A1))) Note: wb must already be saved to work. HTH Jason Atlanta, GA
Try: =RIGHT(CELL("filename",A1),LEN(CELL("filename",A1))-FIND ("]",CELL("filename",A1))) Note: wb must already be saved to work. HTH Jason Atlanta, GA
