Excel VBA - to make it impossible for more than one cell to get selected

[2Took]

Hi,

I'm using below code, in BeforeDoubleClick, but for some reason, sometimes, multiple cells get selected down from a target cell, and obviously the subsequent code does not run - which is good.

But what code do I use to make it impossible for more than one cell to get selected?
So that only the first one Double Clicked on gets selected.

If Target.Cells.count > 1 Then Exit Sub

 

[DanteAmor]

You can put your complete code.
In the double click event, only a double click on a cell is possible, unless you are double clicking on a merged cell.
Are you double clicking on a merged cell?

 

[2Took]

You can put your complete code.
In the double click event, only a double click on a cell is possible, unless you are double clicking on a merged cell.
Are you double clicking on a merged cell?

Not a merged cell.
But what code do I use to make it impossible for more than one cell to get selected?
So that only the first one Double Clicked on gets selected.

 

[DanteAmor]

You can put your complete code.

And an example from your sheet, use XL2BB tool.

Help us help you, put the complete macro, an example of the sheet or upload your file and explain what you are doing to cause the problem to occur.
And it also explains what the end goal is, maybe you need to run the code in multiple cells. I don't know.


You could upload a copy of your file to a free site such www.dropbox.com or google drive. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. If the workbook contains confidential information, you could replace it with generic data.

---