Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Specifying 2 sheet names
Hey guys
Below is a working code that says if sheet name in workbook is "template", then bflag=true. I would like it to say if sheet name in workbook is "template" or "variables", then bflag=true If LCase(sh.Name) = "template" Then bFlag = True How would I write this? Thanx Todd |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Specifying 2 sheet names
Todd,
Try a Select Case. E.g., Select Case LCase(sh.Name) Case "template", "variables" bflag = True Case Else bflag = False End Select -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Todd Huttenstine" wrote in message ... Hey guys Below is a working code that says if sheet name in workbook is "template", then bflag=true. I would like it to say if sheet name in workbook is "template" or "variables", then bflag=true If LCase(sh.Name) = "template" Then bFlag = True How would I write this? Thanx Todd |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Specifying 2 sheet names
Todd,
Just a simple Or If LCase(sh.Name) = "template" Or LCase(sh.Name) = "variables" Then bFlag = True -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Todd Huttenstine" wrote in message ... Hey guys Below is a working code that says if sheet name in workbook is "template", then bflag=true. I would like it to say if sheet name in workbook is "template" or "variables", then bflag=true If LCase(sh.Name) = "template" Then bFlag = True How would I write this? Thanx Todd |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sheet Referencing - autofilling sheet names | Excel Worksheet Functions | |||
Cell names = sheet names | Excel Worksheet Functions | |||
Add Names of First Sheet and Automatically Add to Second Sheet | Excel Discussion (Misc queries) | |||
I want to print out the sheet tabs (sheet names) | Excel Worksheet Functions | |||
Sheet names in VBE | Excel Programming |