title: Switching sheets in Excel VBA
body: <p>I'm currently doing this <code>Sheets("Sheet2").Range("A1").Value = 35</code>, but I want to a way to do just this <code>Range("A1").Value = 35</code>, by switching the sheet on a separate line before. I tried <code>Sheets("Sheet2").Select</code>, but that only switches the sheet it displays at the end to sheet 2.</p>