Sub Count_Selection()
Dim cell As Object
Dim count As Long
count = 0
For Each cell In Selection
count = count + 1
Next cell
if count =1 then
MsgBox "N"
elseif count >1 then
msgbox "Y"
end if
End Sub
Sub Count_Selection()
Dim cell As Object
Dim count As Long
count = 0
For Each cell In Selection
count = count + 1
Next cell
if count =1 then
MsgBox "N"
elseif count >1 then
msgbox "Y"
end if
End Sub