Select Defined Range if Selection

[FallingDown]

Hi all

How can I get Excel to select range G to P on all selected cells?

Example: User selects K5 and K10

Result: The selection should be G5:P5 and G10:P10

What I managed is to select the entire rows of the selectio, but how can I limit it to G to P?

Selection.EntireRow.Select

[Norie]

Perhaps.

Intersect(Selection.EntireRow, Range("G:P")).Select

[FallingDown]

Perfect! Thank you!