How to know if multiple cells were selected

[itsmaheshp]

Hi,

I want to know if multiple cells were selected in the Worksheet_SelectionChange(ByVal Target As Range) Event in Excel.

Please advice.

Thanks,
Mahesh

[mikerickson]

If 0 < Target.Cells.Count Then
MsgBox "MultiCell Selection"
End If

[Charlize]

Selection.Count
Charlize

[Charlize]

If 0 < Target.Cells.Count Then
MsgBox "MultiCell Selection"
End IfAlways msgbox that pops up. Better use 1.

Charlize

[itsmaheshp]

thank you very much for your quick responce..

[mikerickson]

:banghead: Yes, a selection always has 1 or more cells