M Mark Sep 26, 2003 #1 Can some tell me how to get a cell to automatically equal what the worksheet tab is named.
J Jason Morin Sep 26, 2003 #2 =MID(CELL("filename",A1),FIND("]",CELL("filename",A1)) +1,255) Note: file must be already be saved for this to work. HTH Jason Atlanta, GA
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1)) +1,255) Note: file must be already be saved for this to work. HTH Jason Atlanta, GA
J Jim Sep 26, 2003 #3 Jason, hopefully you will read this. I was also looking for this answer. Thanks for your help. Would you mind explaining how and why this works. Thanks Jim -----Original Message----- =MID(CELL("filename",A1),FIND("]",CELL("filename",A1)) +1,255) Note: file must be already be saved for this to work. HTH Jason Atlanta, GA -----Original Message----- Can some tell me how to get a cell to automatically equal what the worksheet tab is named. . Click to expand... . Click to expand...
Jason, hopefully you will read this. I was also looking for this answer. Thanks for your help. Would you mind explaining how and why this works. Thanks Jim -----Original Message----- =MID(CELL("filename",A1),FIND("]",CELL("filename",A1)) +1,255) Note: file must be already be saved for this to work. HTH Jason Atlanta, GA -----Original Message----- Can some tell me how to get a cell to automatically equal what the worksheet tab is named. . Click to expand... . Click to expand...
G GB Sep 26, 2003 #4 "J.E. McGimpsey" [and to the older coders, is a familiar large binary integer (i.e., 2^8 - 1, or 11111111)]. Click to expand... There are 10 types of person - those who understand binary and those who don't.
"J.E. McGimpsey" [and to the older coders, is a familiar large binary integer (i.e., 2^8 - 1, or 11111111)]. Click to expand... There are 10 types of person - those who understand binary and those who don't.
