Mr.M.Johansson
New Member
- Joined
- Aug 13, 2010
- Messages
- 2
Hey everyone!
I have a error that occurs in the middle of the code:
Private Sub Worksheet_Change(ByVal Target As Range)
.
.
.
Sheets("Komponenter").Select
-> Range("b2").Select <-
Selection.End(xlDown).Select
.
.
.
End sub
The code is pretty long so i chosed not to post it all....
I looked around on the forum and seen similar problems with the most common solution to exclude the ".select" command and chose other commands instead, but still.....
The .select command occurs several times before in the code without any errors, i can take the same code and insert it in another sub and run it without any errors.
I will exchange most of the .select commands in time, when i stumble on better solutions but i want to be able to use the .select commands for a while more.
Is there any solution without replacing the .select command?
thankful for any help
/Martin Johansson
I have a error that occurs in the middle of the code:
Private Sub Worksheet_Change(ByVal Target As Range)
.
.
.
Sheets("Komponenter").Select
-> Range("b2").Select <-
Selection.End(xlDown).Select
.
.
.
End sub
The code is pretty long so i chosed not to post it all....
I looked around on the forum and seen similar problems with the most common solution to exclude the ".select" command and chose other commands instead, but still.....
The .select command occurs several times before in the code without any errors, i can take the same code and insert it in another sub and run it without any errors.
I will exchange most of the .select commands in time, when i stumble on better solutions but i want to be able to use the .select commands for a while more.
Is there any solution without replacing the .select command?
thankful for any help
/Martin Johansson