What would the correct script be for the following; should i be writing all the users names with an OR ?
easier to just list the sheets not to use, which should remain constant and allow names sheets to be dynamic
for each ws in thisworkbook.worksheets
   select case ws.name
     case "Summary","Google Data","Report Manager Data","Merged List","How it should be" ' add others if required
             ' do nothing
     case else
             ' code here
  end select
next
I'm still getting an run time error on
hmmmm autofit is a method, not a property, remove = true