select single cell 1

[faxof]

is there a way to check if a user has selected more than one cell?
at the top of my macro i want something like. . .

If selected.cells > 1 then exit sub

but i'm not to sure of the syntax

any ideas?

faxof

 

[Loomah]

Hi
Something like this would do it - you were nearly there!!

If Selection.Cells.Count > 1 Then
MsgBox "DOH"
'selects the active cell
ActiveCell.Select
' OR maybe the top left cell
'Selection.Range("A1").Select
' or do whatever
End If

Happy Friday
;-) If a man says something and there are no women there to hear him, is he still wrong?