<div>
I don't know exactly what byundt said and I don't know what you want to do with the active (blank) cell, but you can still refer to it's address, value or any other property.
</div>


I don't know exactly what byundt said and I don't know what you want to do with the active (blank) cell, but you can still refer to it's address, value or any other property.

<div>
The thing you should avoid if at all possible is selecting things <i>in your code</i>, because the user may change what is selected while the macro is running which may lead to unexpected results, and also &quot;selecting&quot; takes time. That time may be very small but it can add up.
</div>


The thing you should avoid if at all possible is selecting things in your code, because the user may change what is selected while the macro is running which may lead to unexpected results, and also "selecting" takes time. That time may be very small but it can add up.

Executive Assistant

Magpie Bavarde

<div>
That's crystal clear. Thank you so much !!
</div>


That's crystal clear. Thank you so much !!

<div>
<div class="content wysiwyg-content">
Hello the experts,<br />
<br />
byundt has been kind enough to help me improve several VBA codes<br />
<br />
He suggests each time to use &quot;ActiveCell&quot; rather than &quot;Selection&quot; but also tells that if I got empty cells, then &quot;ActiveCell&quot; won't work and it's better to use &quot;Selection&quot;<br />
<br />
As I often have empty cells in my files I'm tempted to always choose the &quot;Selection&quot; option<br />
<br />
I would just like to know why &quot;ActiveCell&quot; is better and what are the risks with &quot;Selection&quot; ?<br />
<br />
Thank you very much for your help,<br />
<br />
Mélanie
</div>
</div>


Hello the experts,

byundt has been kind enough to help me improve several VBA codes

He suggests each time to use "ActiveCell" rather than "Selection" but also tells that if I got empty cells, then "ActiveCell" won't work and it's better to use "Selection"

As I often have empty cells in my files I'm tempted to always choose the "Selection" option

I would just like to know why "ActiveCell" is better and what are the risks with "Selection" ?

Thank you very much for your help,

Mélanie

VBA : ActiveCell vs. Selection

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.

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

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.