Select rows when multiple cells are selected

[Chasethewind]

Hello,

I have multiple cells selected in the worksheet. I want to select all the rows that have selected cells.


Thank you,

[sglife]

Press Ctrl and click the leftmost row number

[Chasethewind]

I have a lot of cells highlighted, and it will take along time to click on each row. Is there a command (programming) that can do this?

[sglife]

A sample please.

[Chasethewind]

I only highlighted a few cells, however there will be a lot more highlighted. How can I select all the rows at once if there is a highlighted cell without clicking each row?

Thank you for trying to help me.

[ChemistB]

There is no shortcut. SHIFT + Spacebar highlights the active row (e.g. from whichever cell is active) but not the other highlighted cells. You'll need VBA.

[benji*]

There is no shortcut. SHIFT + Spacebar highlights the active row (e.g. from whichever cell is active) but not the other highlighted cells. You'll need VBA.

I would quite like to know the VBA for that.

I thought it might just be

Please Login or Register  to view this content.

but this just highlights the row of the last selected cell rather than the rows of all selected cells.

Thanks for any help

[ChemistB]

Please Login or Register  to view this content.