Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
If tab exists "Yes", else "No"
I have a number of tabs in a spreadsheet, I want a simple Yes/No index that
indicates whether or not a tab is present as some tabs will be present for some managers, but not for others. How do I do that? Thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
If tab exists "Yes", else "No"
Try something like this:
For Each sh In ActiveWorkbook.Worksheets If (sh.Name) < "Password" Then 'do something here End if Next Hope that helps ya, Ryan--- -- RyGuy "Nico" wrote: I have a number of tabs in a spreadsheet, I want a simple Yes/No index that indicates whether or not a tab is present as some tabs will be present for some managers, but not for others. How do I do that? Thanks! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
If tab exists "Yes", else "No"
Sorry, perhaps I wasn't clear enough.
I need some sort of index to indicate which sheets are present. For example, the workbook tabs would look like this: [Index] [Program A] [Program C] The [Index] tab would have a table indicating which sheets were present: Program A Yes Program B No Program C Yes Any ideas? Thanks! "ryguy7272" wrote: Try something like this: For Each sh In ActiveWorkbook.Worksheets If (sh.Name) < "Password" Then 'do something here End if Next Hope that helps ya, Ryan--- -- RyGuy "Nico" wrote: I have a number of tabs in a spreadsheet, I want a simple Yes/No index that indicates whether or not a tab is present as some tabs will be present for some managers, but not for others. How do I do that? Thanks! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
If tab exists "Yes", else "No"
Maybe you could use this UDF (place the code in a Module)...
Function IsSheetNamePresent(SheetName As String) As String On Error GoTo Done IsSheetNamePresent = "No" If Worksheets(SheetName).Visible Then IsSheetNamePresent = "Yes" Done: End Function With your sheet names in Column A (starting in A1), put this in B1... =IsSheetNamePresent(A1) and copy down. Rick "Nico" wrote in message ... Sorry, perhaps I wasn't clear enough. I need some sort of index to indicate which sheets are present. For example, the workbook tabs would look like this: [Index] [Program A] [Program C] The [Index] tab would have a table indicating which sheets were present: Program A Yes Program B No Program C Yes Any ideas? Thanks! "ryguy7272" wrote: Try something like this: For Each sh In ActiveWorkbook.Worksheets If (sh.Name) < "Password" Then 'do something here End if Next Hope that helps ya, Ryan--- -- RyGuy "Nico" wrote: I have a number of tabs in a spreadsheet, I want a simple Yes/No index that indicates whether or not a tab is present as some tabs will be present for some managers, but not for others. How do I do that? Thanks! |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
If tab exists "Yes", else "No"
PUt the names in A1:An, and in B1 and copy down
=IF(ISERROR(INDIRECT("'"&A1&"'!A1")),"No","Yes") -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Nico" wrote in message ... Sorry, perhaps I wasn't clear enough. I need some sort of index to indicate which sheets are present. For example, the workbook tabs would look like this: [Index] [Program A] [Program C] The [Index] tab would have a table indicating which sheets were present: Program A Yes Program B No Program C Yes Any ideas? Thanks! "ryguy7272" wrote: Try something like this: For Each sh In ActiveWorkbook.Worksheets If (sh.Name) < "Password" Then 'do something here End if Next Hope that helps ya, Ryan--- -- RyGuy "Nico" wrote: I have a number of tabs in a spreadsheet, I want a simple Yes/No index that indicates whether or not a tab is present as some tabs will be present for some managers, but not for others. How do I do that? Thanks! |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
If tab exists "Yes", else "No"
very nice Bob
-- Gary''s Student - gsnu200795 "Bob Phillips" wrote: PUt the names in A1:An, and in B1 and copy down =IF(ISERROR(INDIRECT("'"&A1&"'!A1")),"No","Yes") -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Nico" wrote in message ... Sorry, perhaps I wasn't clear enough. I need some sort of index to indicate which sheets are present. For example, the workbook tabs would look like this: [Index] [Program A] [Program C] The [Index] tab would have a table indicating which sheets were present: Program A Yes Program B No Program C Yes Any ideas? Thanks! "ryguy7272" wrote: Try something like this: For Each sh In ActiveWorkbook.Worksheets If (sh.Name) < "Password" Then 'do something here End if Next Hope that helps ya, Ryan--- -- RyGuy "Nico" wrote: I have a number of tabs in a spreadsheet, I want a simple Yes/No index that indicates whether or not a tab is present as some tabs will be present for some managers, but not for others. How do I do that? Thanks! |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
If tab exists "Yes", else "No"
That works perfectly, you're a genius. Thank you!!
"Bob Phillips" wrote: PUt the names in A1:An, and in B1 and copy down =IF(ISERROR(INDIRECT("'"&A1&"'!A1")),"No","Yes") -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Nico" wrote in message ... Sorry, perhaps I wasn't clear enough. I need some sort of index to indicate which sheets are present. For example, the workbook tabs would look like this: [Index] [Program A] [Program C] The [Index] tab would have a table indicating which sheets were present: Program A Yes Program B No Program C Yes Any ideas? Thanks! "ryguy7272" wrote: Try something like this: For Each sh In ActiveWorkbook.Worksheets If (sh.Name) < "Password" Then 'do something here End if Next Hope that helps ya, Ryan--- -- RyGuy "Nico" wrote: I have a number of tabs in a spreadsheet, I want a simple Yes/No index that indicates whether or not a tab is present as some tabs will be present for some managers, but not for others. How do I do that? Thanks! |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
If tab exists "Yes", else "No"
"Gary''s Student" wrote in message ... very nice Bob Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
If changed array formula reduce ""\""\""\ - signs to #Missing, will it make ... | Excel Programming |