Vba Select Worksheet Without Name. You MUST activate the sheet before selecting a range on that sheet. You can use either a Worksheet name or Worksheet number.
Microsoft ISV Community Center. > Visual Basic for Applications (VBA). This article will discuss the ActiveSheet object in VBA. What exactly are you trying to do and You can also name the range and then you can just use anywhere without activating.
Microsoft ISV Community Center. > Visual Basic for Applications (VBA).
A worksheet has only one active cell.
How to copy sheet in Excel with VBA. I am using Sheets("tab_name_goes_here").select in VBA. If you're a loyal follower of my VBA Tutorials Blog, I'm sure.