Combine x1down and x1right

[CraigMcKee]

Can I combine these to select an unknown range from (example) C7:L20?

At the moment I can start in C7 and select everything in the column using:

Please Login or Register  to view this content.

Which works fine. I then tried:

Please Login or Register  to view this content.

But this didn't work. Any tips?

[nilem]

try

Please Login or Register  to view this content.

[CraigMcKee]

Thanks, but that selects things above it too, which I don't want....I only want things below and to the right.

[nilem]

maybe so

Please Login or Register  to view this content.

[CraigMcKee]

Ah, thank you. I've managed to do it in two lines

Please Login or Register  to view this content.

I thought, there just might be a nice, neat one liner....

Appreciate the help.

[jindon]

I thought, there just might be a nice, neat one liner....

Please Login or Register  to view this content.

[CraigMcKee]

Thank you!