<div>
Dear both, <br />
<br />
great job. Works as desired. Thank you very much for your professional help.<br />
<br />
Regards, Andreas
</div>


Dear both,

great job. Works as desired. Thank you very much for your professional help.

Regards, Andreas

<div>
<div class="content wysiwyg-content">
Dear Experts: <br />
<br />
I would like to have the following code snippet to start off my macro. <br />
<br />
The macro is to check whether the user has currently more than one cell selected. <br />
<br />
Helyp is much appreciated. Thank you very much in advance. <br />
<br />
Regards, Andreas
</div>
</div>


Dear Experts: 

I would like to have the following code snippet to start off my macro. 

The macro is to check whether the user has currently more than one cell selected. 

Helyp is much appreciated. Thank you very much in advance. 

Regards, Andreas

Check whether more than one cell is selected (contiguous or non-contiguous selections) using VBA

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.