Navigate to a NamedRange from current worksheet to another Worksheet

[inddon]

Hello There,

I have a few NamedRange(s) defined in Sheet1 & Sheet2

When the user hits enter key on the last named range in Sheet1, the control should go to the first named range in Sheet2 (namedrange "FDescription"). But it doesn't

Below code:

This doesn't work:

Worksheets("Sheet2").Range("FDescription").Select

This works:

Worksheets("Sheet2").Select
Worksheets("Sheet2").Range("FDescription").Select

I would like to know what is wrong in the first code as it does not navigate to worksheet "Sheet2"


Thanks & regards,
Don

 

[Chihiro]

You first need to have worksheet active before you can select a range within it.

 

[p45cal]

You can't select something on an inactive sheet.
You can still do it in one line though:

Application.Goto Worksheets("Sheet2").Range("FDescription")

If the range name has a workbook scope you'll get away with:

Application.Goto Range("FDescription")

 

[Stevie]

I use:

Application.Goto [FDescription]

 

[inddon]

You can't select something on an inactive sheet.
You can still do it in one line though:

Application.Goto Worksheets("Sheet2").Range("FDescription")

If the range name has a workbook scope you'll get away with:

Application.Goto Range("FDescription")

Thank you p45cal for your tips. Learned something new today