If only one cell is selected then...

[The Tamer]

Hi

How do I say in vba code:

If only one cell is selected then do X
otherwise
do Y

Thanks

Tamer

 

[Norie]

How about:

If Selection.Cells.Count Then 
' Do something
Else
' Do something else
End If

 

[a7n9]

Modification on Norie's post.

If Selection.Cells.Count > 1 Then
' Do something - A range is selected
Else
' Do something else - A cell is selected
End If

 

[Norie]

Modification on Norie's post.

Thanks

I'm really going to have to double check my posts before submitting them.

 

[The Tamer]

Thanks Both

Much appreciated.

Tamer