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