Worksheet_Deactivate error code 1004

[Ironman]

Hi

I wrote the below code so the sheet opens at the bottom row.

Private Sub Worksheet_Deactivate()
Range("A23358").End(xlUp).Offset(-15, 0).Select
End Sub

I didn't write this as a Worksheet_Activate event because if I did that then the links I've created from other sheets to other rows in this sheet won't run.

I don't know why I get Error 1004 though.

Help appreciated.

Many thanks!

 

[Joe4]

I don't use the worksheet_deactivate event code much, but it seems to me that deactivating by activating another tab makes the other tab the activesheet. So, it's no longer possible to selecet any cell on the dectivated sheet the code is written for. You will always get a 1004 error on attempting to do that. Run the simple code below as is and it runs fine. Then uncomment the cell selection line and run it again.

Private Sub Worksheet_Deactivate()
MsgBox Me.Name & " has been DEACTIVATED"
Range("A1").Value = "DEACTIVATED"
'Range("A1").Select
End Sub

JoeMo,
Thanks for the assist. Like you, I seldom use this code. I was "down in the weeds" trying to detect logic problems with the code, and that basic fact did not occur to me, but it makes perfect sense!

 

[JoeMo]

@JoeMo yes, your logic makes sense. It's no big deal, I must admit I've always struggled understanding the worksheet_deactivate event.
Many thanks for your help anyway Joe4 and JoeMo

Glad we could help!