Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What’s the difference between using Select and Application.Goto?

April 26, 2017difference select

0

Posted

What’s the difference between using Select and Application.Goto?

1 Answer

0

Posted

Range.Select will select a range on the active worksheet only. Use Application.Goto to select a range on any worksheet in a workbook. Application.Goto may or may not make another sheet the active sheet. The Goto method also lets you scroll the sheet so the range is in the upper left corner.