Why is this happening?

[Bub_the_Zombie]

Hey everyone I have a piece of vba code that is very long and works on several sheets. Because of the selecting ranges for copy and pasting I added a command to select a single cell after the commands were done so the blue highlight selection field would go away. For some reason it works on every page except one, why is that?

WS works, WS2 does not

  WS.Range("N1").Select
  WS2.Range("N1").Select

 

[BQardi]

Because WS is already selected, WS.Range("N1").Select works, but WS2 is NOT selected, that is why WS2.Range("N1").Select won't work...
You need to select the worksheet before selecting cells:

WS.Select
WS.Range("N1").Select
WS2.Select
WS2.Range("N1").Select

 

[Bub_the_Zombie]

Thank You!

That was driving me nuts, works great now.

 

[Sektor]

I wonder if these two lines come together? If yes, then what's the point of selecting cells? Why would you select cells when you can avoid this unnecessary operation (which also slows down code execution speed).

 

[Bub_the_Zombie]

I added the cell selection command because on every page of the worksheet the last range copied was highlighted in blue, and it was annoying. Had to keep clicking a random cell on each page to remove the highlight from the range.

The lines are placed back to back, exactly written above.