I need to detect if multiple cells are selected. but I'm unsure of how to do this.
Lee
I need to detect if multiple cells are selected. but I'm unsure of how to do this.
Lee
[vba]If Selection.Cells.Count > 1 Then
End If[/vba]
-------------------------------------------------
The more details you give, the easier it is to understand your question. Don't save the effort, tell us twice rather than not at all. The amount of info you give strongly influences the quality of answer, and also how fast you get it.
To be pedantic
[VBA]
MsgBox Selection.Cells.Count * ActiveWorkbook.Windows(1).SelectedSheets.Count
[/VBA]
as I found out when my Copy utility failed!
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Thank you for the help that is exactly what I needed.
Jimmy the Hand: I thought I gave all pertinent details, what was lacking in my question?
Nothing wrong there. That was only my signature, which you can see below all my posts. Sorry for the misunderstanding.Originally Posted by leeweaver
Jimmy
-------------------------------------------------
The more details you give, the easier it is to understand your question. Don't save the effort, tell us twice rather than not at all. The amount of info you give strongly influences the quality of answer, and also how fast you get it.