multiple active cells, how to selected all coresponding rows

[bsapaka]

So for example if I have a1, a5, and a6 selected, I want to be able to select row 1, 6, and 7 in one action. Is there a hotkey for this, and if not what macro could I use?

ActiveCell.EntireRow.Select only gives me one row. I want to be able to select all of them at once

[HaHoBe]

Hi, bsapaka,

there will always be only one ActiveCell but you may rely on the selection you made:

Please Login or Register  to view this content.

although I think itīs unnecessary to use Select or Activate in most cases when using VBA.

Ciao,
Holger