Application.Goto

Paella1

Active Member
Joined
Mar 10, 2005
Messages
382
What is the difference between Application.GoTo and Select?

(Other than that Select offends the programming gods)
 

Some videos you may like

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
GoTo activates the target worksheet, if it's not already active. Select only works on the ActiveSheet. The behaviour is the same as in the User Interface.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,624
Messages
5,523,968
Members
409,547
Latest member
AW2020

This Week's Hot Topics

Top