Solved: How to detect multiple cell selection

[leeweaver]

I need to detect if multiple cells are selected. but I'm unsure of how to do this.

Lee:bug:

[JimmyTheHand]

If Selection.Cells.Count > 1 Then

End If

[mdmackillop]

To be pedantic

MsgBox Selection.Cells.Count * ActiveWorkbook.Windows(1).SelectedSheets.Count


as I found out when my Copy utility failed!

[leeweaver]

Thank you for the help that is exactly what I needed.

Jimmy the Hand: I thought I gave all pertinent details, what was lacking in my question?

[JimmyTheHand]

I thought I gave all pertinent details, what was lacking in my question?


Nothing wrong there. That was only my signature, which you can see below all my posts. Sorry for the misunderstanding.

Jimmy