By VBA, How to know User has selected one or several entire rows orther than some c

[Amolin]

By VBA, How to know User has selected one or several entire rows orthe
than some cells

 

[Frank Kabel]

Hi
msgbox selection.rows.count

 

[Debra Dalgleish]

To check that at least one entire row is selected, you can count the
columns in the selection

Selection.Columns.Count = ActiveSheet.Columns.Count