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

[AlvaroSiza]

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

[shg]

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.

[AlvaroSiza]

I don't understand the question.

Thanks Shg from one Texan to another. I'm green as grass and apologize if this is elementary.

I guess I'm just verifying that the code should be in the worksheet (Right-Click Command Button >> View Code >> Code Location) like

Please Login or Register  to view this content.

versus

Please Login or Register  to view this content.

Where ToFlexHome equals:

Please Login or Register  to view this content.

[shg]

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.

[AlvaroSiza]

Great. Thanks so much for your time and thoughts.

-AS