Application.Goto

P

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)
 

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop
Sort by date Sort by votes
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.
 
Upvote 0
You must log in or register to reply here.

Similar threads

PIsabel
  • Question
Transpose columns to rows but without blanks
Replies
1
Views
176
bobaol
B
G
  • Question
VBA help - copy cells from specific table to specific table on another sheet.
Replies
0
Views
296
GardianAngelUK
G
K
  • Solved
how to 'deselect' textframes and shapes? (on a worksheet...)
Replies
7
Views
224
RoryA
RoryA
C
  • Solved
Userform data as a date value
Replies
2
Views
96
colinharwood
C
W
  • Locked
  • Question
Command buttons changing to pictures?
Replies
1
Views
170
wackywoo105
W

Forum statistics

Threads
1,215,036
Messages
6,122,796
Members
449,095
Latest member
m_smith_solihull

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top