named range for rows only - not worksheet

[hillary]

Hi - I want to name a range that will select the same rows no matter what worksheet I am on. For example - if I call it "selection" - whenever I pick selection it will choose rows 20 to 25 no matter what worksheet I am on in the file. Any ideas?

 

[XOR LX]

Hi.

Not sure what you mean by "pick", but try defining it as:

=!$20:$55

Regards

 

[hillary]

You are the best! thank you!

 

[XOR LX]

Sure! Cheers!