I can't find a good answer via searching (maybe I'm asking the wrong way).
When switching from one worsheet to another worksheet (within the same workbook), which is the preferred/correct way to switch,
Sheets("sheet name").Select or
Sheets("sheet name").Activate?
I am using Excel 2007.
Thanks,
Shawn
When switching from one worsheet to another worksheet (within the same workbook), which is the preferred/correct way to switch,
Sheets("sheet name").Select or
Sheets("sheet name").Activate?
I am using Excel 2007.
Thanks,
Shawn