What is the difference between activate and select

Professional Input Forms in Excel. Author: Don. Send Emails from Excel Multiple Methods. Similar Content on TeachExcel. Both pr Automatically Highlight the Active or Selected Cell Macro : This macro will highlight the active cell in any excel spreadsheet with a color selected i Highlight the Row and Column of the Selected Cell Macro : This macro will highlight the row and column of the active cell.

This will fill the column Tutorial Details. Similar Content. In Microsoft Excel, you usually select a cell or cells and then perform an action, such as formatting the cells or entering values in them. In Visual Basic, it is usually not necessary to select cells before modifying them. For example, to enter a formula in cell D6 using Visual Basic, you do not need to select the range D6. Just return the Range object for that cell, and then set the Formula property to the formula you want, as shown in the following example.

For more information and examples of using other methods to control cells without selecting them, see How to: Reference Cells and Ranges. The Select method activates sheets and objects on sheets; the Selection property returns an object that represents the current selection on the active sheet in the active workbook.

Before you can use the Selection property successfully, you must activate a workbook, activate or select a sheet, and then select a range or other object using the Select method. The macro recorder will often create a macro that uses the Select method and the Selection property. The following Sub procedure was created using the macro recorder, and it shows how Select and Selection work together.

Much appreciated. Joined Sep 3, Messages 10, Keep in mind also that Selects can largely be avoided. Apopka - nice town, got friends there. Didn't know NG was there Joined Jun 19, Messages 10, A couple of other thoughts on the subject.

You must log in or register to reply here. Similar threads S. Question Using active sheet instead of using sheet name in a two function code. Replies 4 Views Oct 2, GWteB. Solved Closing workbook after pasting. Chewyhairball Oct 5, Excel Questions 2.

Replies 10 Views Replies 3 Views Oct 30, dmt Question Split data to separate worksheets based on column value. Replies 1 Views Oct 26, elitef. Solved VBA Faster avoiding ".