General Navigation Best Practice Question: Application.GoTo vs. Range.Select

Assume a command button is used to call a sub which navigates to a range. Assume the target range is FlexHome.

Is there any reason I should not be using

Please Login or Register  to view this content.

in place of calling

Please Login or Register  to view this content.

through which

Please Login or Register  to view this content.

is run?

Also, is there any reason that

Please Login or Register  to view this content.

should be placed in a module and called versus placing the code directly at the worksheet level?

Many thanks!

~AS

I would use Application.GoTo

Also, is there any reason that

Please Login or Register  to view this content.

should be placed in a module and called versus placing the code directly at the worksheet level?

I don't understand the question.

There are good reasons to parse code between class modules and standard modules according to the nature of functionality they provide, but this doesn't fall under any of them.

If you instead had

Please Login or Register  to view this content.

... then the latter might reasonably go in a code module because it is non-specific to any worksheet or event, but invoking a procedure to replace a single simple line of code is ... not good.