Need a formula to tell me that a certain worksheet exists
Posted by Veronica on February 28, 2001 1:59 PM
I need a formula to make reference to a sheet name not a cell; I mean when a sheet, let's call it Fee2000, exists in my workbook I want to add 2+3, when it does not exist add 500+100. I tried to use Address function but it does not update; when I changed the sheet name from Fee2000 to Fee2001, it did not update to the new name so instead to add 2+3 it added 500+100. In other words I need to make a relative reference to a sheet name. Any help greatly appreciated.