how to deselect selected Ranges

[bestox]

i use an excel workbook with several excel sheets. after running a makro, some ranges in some sheets are selected.

how can i deselect them? (due to optical reasons)

This does not work:

- Application.Goto Reference:=Worksheets("Tabelle1").Range("A1")
- Application.CutCopyMode = False

Thanks a lot!

 

[RoryA]

You could:
1. Change your macro so that it doesn't select anything, which is good practice and more efficient (it is rarely necessary to select anything in code)
2. You could loop each sheet, selecting it and and selecting a specific cell.

 

[Domski]

The general rule is that it's almost never necessary to actually select cells as part of running a macro but if you have to and want to just end with one selected then:

Worksheets("Sheet1").Activate
Range("A1").Select
Application.CutCopyMode = False

Should do the trick.

Dom

 

[bestox]

@Dom

Have tried yours, but other ranges (in other sheets of the workbook) are still selected. any idea why this is?

 

[bestox]

.

 

[stanleydgromjr]

bestox,

Please post your macro code with code tags.


At the beginning of your posted code, enter the following without the quote marks:
["code"]


Your code goes here.


At the end of your posted code, enter the following without the quote marks:
["/code"]


Have a great day,
Stan

 

[bestox]

my fault, stan. i ll do so in future!

 

[pgc01]

@Dom

Have tried yours, but other ranges (in other sheets of the workbook) are still selected. any idea why this is?

Dom's code is just dealing with Sheet1. To do it for all worksheets, try:

Sub Test()
 
Worksheets.Select
Range("A1").Select
Worksheets(1).Select
End Sub

Remark: as you have already read, using select in vba is usually not necessary, just makes the code less efficient and more difficult to read.
You may consider the option to go back to your code and change it.

 

[bestox]

Dom's code is just dealing with Sheet1. To do it for all worksheets, try:

Sub Test()
 
Worksheets.Select
Range("A1").Select
Worksheets(1).Select
End Sub

Remark: as you have already read, using select in vba is usually not necessary, just makes the code less efficient and more difficult to read.
You may consider the option to go back to your code and change it.

i ll do so next time.

your advice works, thank s a lot!

SOLVED!