Skip to main content
2 of 3
added 14 characters in body
Taylor Raine
  • 8.7k
  • 2
  • 27
  • 51

#Address Sheets By Name

Instead of Addressing a WorkSheet object by calling

Application.ActiveSheet
''  Or 
ActiveSheet   

One may use

Sheets(n)  ''  Where `n` is an integer
''  Or 
[Sheet1]

Or More preferably one may access the object directly and use

Sheet1
Taylor Raine
  • 8.7k
  • 2
  • 27
  • 51