title: changing tab color based on tab name excel vba
body: <p>I want to be able to change tab colors based on the name of the tab cell. I tried to have my version choose from a list of names to change the tab name:</p>
  
  <pre><code>Sub SheetTabColor()
  
          Dim mySheets As Worksheets
          Dim mySheet As Worksheet
  
          Set mySheets = Sheets(Array("Christine", "Marina", "Roberto", "Urszula", "Lois", "Matt", "Stephanie", "Sally", "Iryna", "Katherine", "Matthew", "Julio", "Lavinia"))
  
          For Each mySheet In mySheets
              mySheet.Tab.Color = RGB(0, 255, 255)
          Next
  
  
      End Sub
  </code></pre>
  
  <p>After running this script I get an error at the "Set mySheets=" line</p>
  
  <p><a href="https://i.stack.imgur.com/XGbGz.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/XGbGz.png" alt="Error Msg"></a></p>
  
  <p>Any feedback would be appreciated, I understand that i might not even be close.</p>