Specifying 2 sheet names

  • Thread starter Thread starter Todd Huttenstine
  • Start date Start date
T

Todd Huttenstine

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
 
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,

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)
 
Back
Top