View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson[_2_] Chip Pearson[_2_] is offline
external usenet poster
 
Posts: 95
Default 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