In Excel Video 418 we’ll identify ranges on another worksheet in the same workbook. Everything in Excel Video 417 assumed we wanted to select ranges in the worksheet we were in when we ran the code, which is called the active worksheet. By referencing the worksheets object and identifying the worksheet we want to adjust, we can access any of the worksheets in the spreadsheet without changing worksheet tabs as part of our code.
Also notice in Excel Video 418 we used .Value to change the value stored in some of the selected cells. We’ll do a lot more with value in coming Excel Videos. Stay tuned. In Excel Video 419 we’ll select ranges in a different workbook. Thanks for watching.
