---
title: "How to avoid using Select in Excel VBA?"  
description: "How to avoid using Select in Excel VBA?"  
author: "Sandra Emily"  
published: 2023-08-22  
updated: 2023-08-23  
canonical: https://www.mindstick.com/forum/159637/how-to-avoid-using-select-in-excel-vba  
category: "excel"  
tags: ["excel", "excel vba"]  
reading_time: 2 minutes  

---

# How to avoid using Select in Excel VBA?

How to [avoid](https://yourviews.mindstick.com/story/1518/tips-to-avoid-dengue-at-home) using [Select](https://www.mindstick.com/forum/160534/orderby-then-select-vs-select-then-orderby-performance) in [Excel](https://www.mindstick.com/articles/12937/how-to-import-excel-data-in-sql-server-2014) [VBA](https://www.mindstick.com/forum/34883/how-to-we-create-a-data-entry-form-in-microsoft-excel-without-using-vba-programming)?

## Replies

### Reply by Aryan Kumar

There are a few reasons why you might want to avoid using the `Select` method in Excel VBA. Here are a few of the most common ones:

- **The** `Select` **method can slow down your code:** When you use the `Select` method, Excel has to open and close the object each time you want to work with it. This can slow down your code, especially if you are working with large amounts of data.
- **The** `Select` **method can make your code more difficult to read:** When you use the `Select` method, it can be difficult to see what object you are working with. This can make your code more difficult to read and debug.
- **The** `Select` **method can be unnecessary:** In many cases, you can avoid using the `Select` method by using other methods, such as the `Range` method.

If you want to avoid using the `Select` method in Excel VBA, you can use the following techniques:

- Use the `Range` method instead of the `Select` method. The `Range` method allows you to work with a range of cells without having to select them first.
- Use the `With` statement to work with an object without having to select it first. The `With` statement allows you to work with an object as if it were the active object.
- Use named ranges instead of cell references. Named ranges are more efficient than cell references and they can be used without having to select them first.

Here is an example of how to avoid using the `Select` method in Excel VBA:

VBA

```plaintext
Sub Example()

' This code uses the Range method to avoid using the Select method.

Dim rng As Range
Set rng = Range("A1:A10")

rng.Value = 10

End Sub
```

This code will set the value of cells A1 to A10 to 10. It does not use the `Select` method, so it will not slow down the code or make it more difficult to read.


---

Original Source: https://www.mindstick.com/forum/159637/how-to-avoid-using-select-in-excel-vba

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.