PDA

View Full Version : How to know if multiple cells were selected



itsmaheshp
03-25-2009, 06:21 AM
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
03-25-2009, 06:24 AM
If 0 < Target.Cells.Count Then
MsgBox "MultiCell Selection"
End If

Charlize
03-25-2009, 06:25 AM
Selection.Count
Charlize

Charlize
03-25-2009, 06:27 AM
If 0 < Target.Cells.Count Then
MsgBox "MultiCell Selection"
End IfAlways msgbox that pops up. Better use 1.

Charlize

itsmaheshp
03-25-2009, 06:28 AM
thank you very much for your quick responce..

mikerickson
03-25-2009, 06:42 AM
:banghead: Yes, a selection always has 1 or more cells